happy_gril的专栏

关于含税单价和不含税单价的关系记录

happy_gril — Thu, 17 Dec 2020 11:17:15 +0800

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

动态行动态列

happy_gril — Tue, 16 Jun 2020 13:58:09 +0800

/****** Object: StoredProcedure [dbo].[BizOpName_SP] Script Date: 06/16/2020 13:57:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: <...

SQL循环算出移动加权平均

happy_gril — Thu, 15 Aug 2019 17:14:19 +0800

--测试数据 ifnotobject_id(N'Tempdb..#T')isnull droptable#T Go Createtable#T([数量]int,[金额]int,[单价]INT,类型NVARCHAR(20)) Insert#T select10,100,10,'入库'unionall select5,20,5,'入库'unionall se...

号码验证

happy_gril — Fri, 13 Nov 2015 17:10:07 +0800

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) //是否是手机号码

dataset或dataTable转成json串

happy_gril — Wed, 04 Nov 2015 15:59:32 +0800

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

判断时间戳时否有效

happy_gril — Wed, 04 Nov 2015 15:57:03 +0800

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

第一次写oracle触发器，记录一下

happy_gril — Tue, 03 Nov 2015 10:17:29 +0800

CREATE OR REPLACE TRIGGER TR_SELL_SELLLOG AFTER UPDATE ON mis_sell REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE BEGIN if :new.status then insert into mis_selllog (...)

RSA解密java加密串

happy_gril — Tue, 03 Nov 2015 10:10:16 +0800

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

录入单号失去焦点后显示货款

happy_gril — Tue, 03 Nov 2015 09:57:12 +0800

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

asp.net mvc jquery+js+ajax 实现联动

happy_gril — Tue, 03 Nov 2015 09:53:08 +0800

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

dataGridView单元格内容更改事件

happy_gril — Fri, 08 Mar 2013 09:20:17 +0800

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

dataGridView单元格下拉框实现联动

happy_gril — Fri, 08 Mar 2013 09:15:23 +0800

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

sql获取字符ASCII码

happy_gril — Fri, 08 Mar 2013 09:04:39 +0800

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

是否为数值

happy_gril — Thu, 21 Jun 2012 16:08:30 +0800

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

获取ID

happy_gril — Thu, 21 Jun 2012 16:01:31 +0800

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

SQL查询

happy_gril — Thu, 21 Jun 2012 15:51:21 +0800

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

没有可用于 ‘xxxxx’的编辑器，确保已安装文件类型（.xx）的应用程序

happy_gril — Thu, 02 Feb 2012 10:26:28 +0800

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

c#解析JSON总结

happy_gril — Sat, 31 Dec 2011 19:04:14 +0800

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

DataGridView某个单元格只输入小数

happy_gril — Wed, 15 Jun 2011 11:53:00 +0800

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

非常好的asp.net实例

happy_gril — Mon, 23 May 2011 10:13:00 +0800

http://www.cnblogs.com/lovecherry/archive/2006/07/02/440840.aspx