/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BCW.bydr.Model.Cmg_notes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_notes set ");
strSql.Append("AcolletGold=@AcolletGold,");
strSql.Append("coID=@coID,");
strSql.Append("Vit=@Vit,");
strSql.Append("usID=@usID,");
strSql.Append("Stime=@Stime,");
strSql.Append("AllGold=@AllGold,");
strSql.Append("changj=@changj,");
strSql.Append("stype=@stype,");
strSql.Append("Signtime=@Signtime,");
strSql.Append("random=@random,");
strSql.Append("cxid=@cxid");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@AcolletGold", SqlDbType.BigInt, 8),
new SqlParameter("@coID", SqlDbType.NVarChar, 50),
new SqlParameter("@Vit", SqlDbType.Int, 4),
new SqlParameter("@usID", SqlDbType.Int, 4),
new SqlParameter("@Stime", SqlDbType.DateTime),
new SqlParameter("@AllGold", SqlDbType.BigInt, 8),
new SqlParameter("@changj", SqlDbType.NVarChar, 50),
new SqlParameter("@stype", SqlDbType.Int, 4),
new SqlParameter("@Signtime", SqlDbType.DateTime),
new SqlParameter("@random", SqlDbType.Int, 4),
new SqlParameter("@cxid", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.AcolletGold;
parameters[2].Value = model.coID;
parameters[3].Value = model.Vit;
parameters[4].Value = model.usID;
parameters[5].Value = model.Stime;
parameters[6].Value = model.AllGold;
parameters[7].Value = model.changj;
parameters[8].Value = model.stype;
parameters[9].Value = model.Signtime;
parameters[10].Value = model.random;
parameters[11].Value = model.cxid;
SqlHelper.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BCW.bydr.Model.Cmg_notes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Cmg_notes(");
strSql.Append("AcolletGold,coID,Vit,usID,Stime,AllGold,changj,stype,Signtime,random,cxid)");
strSql.Append(" values (");
strSql.Append("@AcolletGold,@coID,@Vit,@usID,@Stime,@AllGold,@changj,@stype,@Signtime,@random,@cxid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AcolletGold", SqlDbType.BigInt, 8),
new SqlParameter("@coID", SqlDbType.NVarChar, 50),
new SqlParameter("@Vit", SqlDbType.Int, 4),
new SqlParameter("@usID", SqlDbType.Int, 4),
new SqlParameter("@Stime", SqlDbType.DateTime),
new SqlParameter("@AllGold", SqlDbType.BigInt, 8),
new SqlParameter("@changj", SqlDbType.NVarChar, 50),
new SqlParameter("@stype", SqlDbType.Int, 4),
new SqlParameter("@Signtime", SqlDbType.DateTime),
new SqlParameter("@random", SqlDbType.Int, 4),
new SqlParameter("@cxid", SqlDbType.Int, 4)
};
parameters[0].Value = model.AcolletGold;
parameters[1].Value = model.coID;
parameters[2].Value = model.Vit;
parameters[3].Value = model.usID;
parameters[4].Value = model.Stime;
parameters[5].Value = model.AllGold;
parameters[6].Value = model.changj;
parameters[7].Value = model.stype;
parameters[8].Value = model.Signtime;
parameters[9].Value = model.random;
parameters[10].Value = model.cxid;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList Cmg_notes</returns>
public IList <BCW.bydr.Model.Cmg_notes> GetCmg_notess(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <BCW.bydr.Model.Cmg_notes> listCmg_notess = new List <BCW.bydr.Model.Cmg_notes>();
string sTable = "tb_Cmg_notes";
string sPkey = "id";
string sField = "ID,AcolletGold,coID,Vit,usID,Stime,AllGold,changj,stype,Signtime,random,cxid";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listCmg_notess);
}
while (reader.Read())
{
BCW.bydr.Model.Cmg_notes objCmg_notes = new BCW.bydr.Model.Cmg_notes();
objCmg_notes.ID = reader.GetInt32(0);
objCmg_notes.AcolletGold = reader.GetInt64(1);
objCmg_notes.coID = reader.GetString(2);
objCmg_notes.Vit = reader.GetInt32(3);
objCmg_notes.usID = reader.GetInt32(4);
objCmg_notes.Stime = reader.GetDateTime(5);
objCmg_notes.AllGold = reader.GetInt64(6);
objCmg_notes.changj = reader.GetString(7);
objCmg_notes.stype = reader.GetInt32(8);
objCmg_notes.Signtime = reader.GetDateTime(9);
objCmg_notes.random = reader.GetInt32(10);
objCmg_notes.cxid = reader.GetInt32(11);
listCmg_notess.Add(objCmg_notes);
}
}
return(listCmg_notess);
}
/// <summary>
/// 得到相同usID最后一个usID
/// </summary>
public BCW.bydr.Model.Cmg_notes GetusID(int usID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 usID from tb_Cmg_notes");
strSql.Append("order by usID desc");
strSql.Append(" where usID=@usID ");
SqlParameter[] parameters =
{
new SqlParameter("@usID", SqlDbType.Int, 4)
};
parameters[0].Value = usID;
BCW.bydr.Model.Cmg_notes model = new BCW.bydr.Model.Cmg_notes();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.ID = reader.GetInt32(0);
model.AcolletGold = reader.GetInt64(1);
model.coID = reader.GetString(2);
model.Vit = reader.GetInt32(3);
model.usID = reader.GetInt32(4);
model.Stime = reader.GetDateTime(5);
model.AllGold = reader.GetInt64(6);
model.changj = reader.GetString(7);
model.stype = reader.GetInt32(8);
model.Signtime = reader.GetDateTime(9);
model.random = reader.GetInt32(10);
model.cxid = reader.GetInt32(11);
return(model);
}
else
{
return(null);
}
}
}
