1．=======================================
/// <summary>
/// 类型转换为文字输出
/// </summary>
/// <param name="a">汇款用途</param>
///审核状态（0未处理，1开始处理，2已汇出，3账号错误）
public static string A(int a)
{
string s = string.Empty;
switch (a)
{
case 0:
s = "未处理";
break;
case 1:
s = "开始处理";
break;
case 2:
s = "已汇出";
break;
case 3:
s = "账号错误";
break;
}
return s;
}
当前月份
value="@DateTime.Now.ToString("yyyy-MM-dd")"
上一个月
value="@DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd")"
开始日期选中后后面的日期不能选之前的
<input type="text" name="txtDate1" id="txtDate1" class="Wdate"onFocus="WdatePicker({ maxDate: '#F{$dp.$D(\'txtDate2\')}' })" style="width:85px;" value="@DateTime.Now.AddMonths(-1).ToString(" yyyy-MM-dd")" />
至
<input type="text" name="txtDate2" id="txtDate2" class="Wdate" onFocus="WdatePicker({ minDate: '#F{$dp.$D(\'txtDate1\')}' })" style="width:85px;" value="@DateTime.Now.ToString(" yyyy-MM-dd")" />
/**/
/// <summary>
/// DES加密
/// </summary>
/// <param name="encryptString"></param>
/// <returns></returns>
public static string DesEncrypt(string encryptString)
{
using (DESCryptoServiceProvider des = new DESCryptoServiceProvider())
{
byte[] inputByteArray = Encoding.UTF8.GetBytes(encryptString);
des.Key = ASCIIEncoding.ASCII.GetBytes(sKey);
des.IV = ASCIIEncoding.ASCII.GetBytes(sKey);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
using (CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(), CryptoStreamMode.Write))
{
cs.Write(inputByteArray, 0, inputByteArray.Length);
cs.FlushFinalBlock();
cs.Close();
}
string str = Convert.ToBase64String(ms.ToArray());
ms.Close();
return str;
}
}
Bootstrap选中一行获取的内容
var getAllData = $("#tb_departments").bootstrapTable('getSelections');//获取表格的所有内容行?
/**/
/// <summary>
/// DES解密
/// </summary>
/// <param name="decryptString"></param>
/// <returns></returns>
public static string DesDecrypt(string decryptString)
{
byte[] inputByteArray = Convert.FromBase64String(decryptString);
using (DESCryptoServiceProvider des = new DESCryptoServiceProvider())
{
des.Key = ASCIIEncoding.ASCII.GetBytes(sKey);
des.IV = ASCIIEncoding.ASCII.GetBytes(sKey);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
using (CryptoStream cs = new CryptoStream(ms, des.CreateDecryptor(), CryptoStreamMode.Write))
{
cs.Write(inputByteArray, 0, inputByteArray.Length);
cs.FlushFinalBlock();
cs.Close();
}
string str = Encoding.UTF8.GetString(ms.ToArray());
ms.Close();
return str;
}
}
Sql 语句 修改某一列并自增
alter table zhuanMoneyInfo drop column ZzId
alter table zhuanMoneyInfo add ZzId int identity(1000,1)
//获取本机IP地址的方法
/// <summary>
/// 获得登录人的IP
/// </summary>
/// <returns></returns>
public static string getIP()
{
string hostname;
System.Net.IPHostEntry localhost;
System.Net.IPAddress localaddr;
hostname = System.Net.Dns.GetHostName();
localhost = System.Net.Dns.GetHostByName(hostname);
localaddr = localhost.AddressList[0];
return localaddr.ToString();
}
//获取本网段IP地址
System.Web.HttpContext.Current.Request.UserHostAddress;
==============================
判断数据重复提交
//在按钮提交之后和AJAX提交之前将按钮设置为禁用
$("input[type=submit]").attr('disabled',true)
$.ajax({
url:'/post.php'
data:{a:1,b,1}
success:function(){
//在提交成功之后重新启用该按钮
$("input[type=submit]").attr('disabled',false)
},
error: function(){
//即使AJAX失败也需要将按钮设置为可用状态，因为有可能是网络问题导致的失败，所以需要将按钮设置为可用
$("input[type=submit]").attr('disabled',false)
}
})
//设置一个对象来控制是否进入AJAX过程
var post_flag = false;
function post(){
//如果正在提交则直接返回，停止执行
if(post_flag) return;
//标记当前状态为正在提交状态
post_flag = true;
$.ajax({//进入AJAX提交过程
url:'/post.php'
data:{a:1,b,1}
success:function(){
post_flag =false; //在提交成功之后将标志标记为可提交状态
},
error: function(){
post_flag =false; //AJAX失败也需要将标志标记为可提交状态
}
})
//将字符串分割然后放进去
string zhlist = entity.ZhList;
string[] zh = zhlist.Split(',');//账户列表作为字符串进行分割
if (val == 1)//消费账户
{
zh[3] = (int.Parse(zh[3]) + money).ToString();
}
else if (val == 0)//现金账户
{
zh[0] = (int.Parse(zh[0]) + money).ToString();//第一个为现金账户
}
zhlist = "";
foreach (var item in zh)
{
zhlist += item + ",";
}
zhlist = zhlist.Substring(0, zhlist.Length - 1);
entity.ZhList = zhlist;
