public int Insert(PREPAID_HIS p)
{
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = string.Format("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;SELECT MAX(P_SYSID) FROM T_PREPAID_HIS WHERE SUBSTRING(P_SYSID,1,8)='{0}' ;", DateTime.Now.ToString("yyyyMMdd"));
string p_sysid = string.Empty;
p_sysid = cmd.ExecuteScalar().ToString();
if (string.IsNullOrEmpty(p_sysid))
{
p_sysid = DateTime.Now.ToString("yyyyMMdd") + "6000001";
}
else
{
p_sysid = (Convert.ToInt64(p_sysid) + 1).ToString();
}
cmd.CommandText = string.Format(@"INSERT INTO T_PREPAID_HIS (U_SYSID,P_SYSID,P_AMOUNT,P_FREEMESSAGE,P_TYPE,P_DATE) VALUES ('{0}','{1}','{2}','{3}',N'{4}','{5}')",
p.U_SYSID, p_sysid, p.P_AMOUNT, p.P_FREEMESSAGE, p.P_TYPE, p.P_DATE);
return(cmd.ExecuteNonQuery());
}
}
}
public List <PREPAID_HIS> DataToPrepaid(DataTable dt)
{
List <PREPAID_HIS> list = new List <PREPAID_HIS>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
List <USER> lu = new T_USER_SQL(connstring).Get_User(dt.Rows[i]["U_SYSID"].ToString());
PREPAID_HIS p = new PREPAID_HIS
{
U_SYSID = dt.Rows[i]["U_SYSID"].ToString(),
USER = lu.Count > 0 ? lu[0] : new USER(),
P_AMOUNT = dt.Rows[i]["P_AMOUNT"].ToString(),
P_FREEMESSAGE = dt.Rows[i]["P_FREEMESSAGE"].ToString(),
P_DATE = dt.Rows[i]["P_DATE"].ToString(),
P_SYSID = dt.Rows[i]["P_SYSID"].ToString(),
P_TYPE = dt.Rows[i]["P_TYPE"].ToString(),
P_ISDEL = dt.Rows[i]["P_ISDEL"].ToString(),
NUM = dt.Rows[i]["NUM"].ToString()
};
list.Add(p);
}
}
return(list);
}
public int Update_pripard_d(PREPAID_HIS p)
{
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = string.Format(@"UPDATE T_USER SET U_FREEMESSAGE=U_FREEMESSAGE-'{0}',U_BALANCE=U_BALANCE-'{1}' WHERE U_SYSID='{2}' AND U_ISDEL='1' ", p.P_FREEMESSAGE, p.P_AMOUNT, p.U_SYSID);
return(cmd.ExecuteNonQuery());
}
}
}
public int Update(PREPAID_HIS p)
{
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = string.Format(@"UPDATE T_PREPAID_HIS SET P_TYPE=N'{0}',P_AMOUNT='{1}',P_FREEMESSAGE='{2}',P_DATE='{3}' WHERE P_SYSID='{4}' AND P_ISDEL='1' ", p.P_TYPE, p.P_AMOUNT, p.P_FREEMESSAGE, p.P_DATE, p.P_SYSID);
return(cmd.ExecuteNonQuery());
}
}
}
public object ModPrepaid(string prepaid)
{
try
{
PREPAID_HIS p = new JavaScriptSerializer().Deserialize <PREPAID_HIS>(prepaid);
PREPAID_HIS po = prepaid_his_sql.QueryByWhere_XP(string.Format(" AND P_SYSID='{0}' ", p.P_SYSID))[0];
if (prepaid_his_sql.Update(p) == 1)
{
user_sql.Update_pripard_u(p, po);
return(new { state = 0, message = "修改成功" });
}
else
{
return(new { state = -1, message = "修改失败" });
}
}
catch (Exception e)
{
return(new { state = -222, message = e.Message });
}
}
