happy_gril的专栏

--当录入不含税单价=110.27时，算出的含税单价是124.61selectHSPrice=ROUND(110.27*1.13,2)--当录入的含税单价=124.6时，算出的不含税单价是110.27selectPrice=ROUND(124.6/1.13,2)单价*面积(结果算出来的金额差了20多，太可怕了) 124.61*2143.30=267076.61 124.60*2143.30=267055.18一个业务员A在做入库单时，含税单价录入124.6另一业务员B在做出库单...

/****** Object: StoredProcedure [dbo].[BizOpName_SP] Script Date: 06/16/2020 13:57:08 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,Name>-- Create date: <...

//判断时间戳时否有效        public string timespan(string timestamp)        {            string str = "";            try            {                DateTime startTime = DateTime.Now;           

public static string ToJson(DataSet dataSet)        {            string jsonString = "{";            foreach (DataTable table in dataSet.Tables)            {                jsonString += "\"

function isidcard(value) // 是否是身份证号{    var reg = /^[1-9]\d{5}[1-9]\d{3}((0\d)|(1[0-2]))(([0|1|2]\d)|3[0-1])\d{3}([0-9]|X)$/;    return reg.test(value);}function isphone(value) //是否是手机号码

update.chtml        $(document).ready(function () {                        $("#TYPEID").change(function () {                $.ajax({                    type: "Post",                    u

$("#SELLID").blur(function () {                $.ajax({                    type: "Post",                    url: "/Distributor/Appeal/BlurData",                    data: { sellid: $(this).val(

今天终于把JSON搞定了，哇咔咔，赶紧写一写，别忘喽～第一步：引用using System.Runtime.Serialization.Json;  我用的是VS2005,  frameWork3.5第二步：（关键代码）DataContractJsonSerializer ser1 = new DataContractJsonSerializer(typeof(EntityOrder[

//RSA解密java加密串        public string decrypt1(string encryptedData)        {            IAsymmetricBlockCipher cipher = new RsaEngine();            byte[] encryptData = Convert.FromBase64String

CREATE OR REPLACE TRIGGER TR_SELL_SELLLOGAFTER UPDATEON mis_sellREFERENCING NEW AS New OLD AS OldFOR EACH ROWDECLAREBEGIN  if :new.status  then     insert into mis_selllog (...)   

第1步：先将第一个下拉框在Load里面填充上数据            dgvCmbObligorType.DataSource = dtPayer;            dgvCmbObligorType.DisplayMember = "name";            dgvCmbObligorType.ValueMember = "id";第2步：使用dataGridView1

DECLARE @addr varchar(50), @len int SELECT @addr = '市西五区北区39号楼1单元201室' SELECT @len = LEN(@addr) DECLARE @a varchar(2) WHILE @len > 0 BEGIN SELECT @a = SUBSTRING(@addr, @len, 1) SELE

private void dataGridView1_CurrentCellDirtyStateChanged(object sender, EventArgs e) { if (dataGridView1.IsCurrentCellDirty) { dataGridView1.CommitEd

  using System.IO.Ports;using System.Threading;using System.IO;namespace SerialPortDemo{    public partial class Form1 : Form    {        bool isStar = false;        Thread threadReceive = null;  

<br /> /// <summary><br />        /// 马赛克效果<br />        ///原理：确定图像的随机位置点和确定马赛克块的大小,然后马赛克块图像覆盖随机点即可.<br />        /// </summary><br />        /// <param name="m_Iimage"></param><br />        /// <param name="val">分割成val*val像素的小区块</param><br />        publi

<br />public  DataSet ImportExcel(string file)<br />        {<br />            FileInfo fileInfo = new FileInfo(file);<br />            if (!fileInfo.Exists) return null; <br />            string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +

<br /><br />//获取本地语言信息//<br />    public static int GetLanguageType()<br />    {<br />        int LanguageType = 0;<br />        CultureInfo ci = System.Threading.Thread.CurrentThread.CurrentCulture;<br />        if (ci.EnglishName.Equals("Chin

private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)        {                           e.CellStyle.BackColor = Color.Aqua;//设置编译时的颜           

VS2005打开视图编辑器时提示“没有可用于 ‘xxxxx’的编辑器，确保已安装文件类型（.xx）的应用程序”。如果遇到这个问题了,并且修复重装打补丁均没有用, 那么请打开VS的命令提示,执行这个命令: devenv /resetskippkgs 重新加载组件即可。

declare @TOrder table(torderID int primary key) insert into @TOrder(torderID) select distinct id from vw_OrderLastStatus ost where ost.status = @statusselect 列名...from 主表join @TOrder tor

//是否为数值        public static bool IsNumber(string text)        {            Regex objNotNumberPattern = new Regex("[^0-9.-]");            Regex objTwoDotPattern = new Regex("[0-9]*[.][0-9]*[.]

新建存储过程CREATE PROCEDURE [dbo].[sp_GetIntKey]  @TableName varchar(100),  @KeyValue int OUTPUT  ASBEGINUPDATE tableIntKeySET @KeyValue = KeyValue = KeyValue + 1WHERE tableName LIKE @T

 body{background:#fff}.Menu {position:relative;width:204px;height:127px;z-index:1;background: #FFF;border:1px solid #000;margin-top:-100px;display:none;}.Menu2 {position: absolute;left:0;top:0;width