public static WE_Project.Model.BMember DataRowToModel(DataRow row)
{
if (row != null)
{
WE_Project.Model.BMember model = new WE_Project.Model.BMember();
if (row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
model.AMID = row["AMID"].ToString();
model.BMID = row["BMID"].ToString();
model.BMBD = row["BMBD"].ToString();
if (row["BMCreateDate"].ToString() != "")
{
model.BMCreateDate = DateTime.Parse(row["BMCreateDate"].ToString());
}
if (row["BMDate"].ToString() != "")
{
model.BMDate = DateTime.Parse(row["BMDate"].ToString());
}
if (row["BMState"].ToString() != "")
{
model.BMState = bool.Parse(row["BMState"].ToString());
}
if (row["BIsClock"].ToString() != "")
{
model.BIsClock = bool.Parse(row["BIsClock"].ToString());
}
if (row["YJCount"].ToString() != "")
{
model.YJCount = decimal.Parse(row["YJCount"].ToString());
}
if (row["YJMoney"].ToString() != "")
{
model.YJMoney = decimal.Parse(row["YJMoney"].ToString());
}
if (row["BCount"].ToString() != "")
{
model.BCount = decimal.Parse(row["BCount"].ToString());
}
if (row["BOutMoney"].ToString() != "")
{
model.BOutMoney = decimal.Parse(row["BOutMoney"].ToString());
}
if (row["FHDays"].ToString() != "")
{
model.FHDays = int.Parse(row["FHDays"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(WE_Project.Model.BMember model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update BMember set ");
strSql.Append(" AMID = @AMID , ");
strSql.Append(" BMID = @BMID , ");
strSql.Append(" BMBD = @BMBD , ");
strSql.Append(" BMCreateDate = @BMCreateDate , ");
strSql.Append(" BMDate = @BMDate , ");
strSql.Append(" BMState = @BMState , ");
strSql.Append(" YJCount = @YJCount , ");
strSql.Append(" YJMoney = @YJMoney , ");
strSql.Append(" BCount = @BCount , ");
strSql.Append(" BIsClock = @BIsClock , ");
strSql.Append(" BOutMoney = @BOutMoney, ");
strSql.Append(" FHDays = @FHDays ");
strSql.Append(" where BMID=@BMID");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@AMID", SqlDbType.VarChar, 20),
new SqlParameter("@BMID", SqlDbType.VarChar, 20),
new SqlParameter("@BMBD", SqlDbType.VarChar, 20),
new SqlParameter("@BMCreateDate", SqlDbType.DateTime),
new SqlParameter("@BMDate", SqlDbType.DateTime),
new SqlParameter("@BMState", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Decimal),
new SqlParameter("@YJMoney", SqlDbType.Decimal),
new SqlParameter("@BCount", SqlDbType.Decimal),
new SqlParameter("@BIsClock", SqlDbType.Bit, 1),
new SqlParameter("@BOutMoney", SqlDbType.Decimal),
new SqlParameter("@FHDays", SqlDbType.Int, 4)
};
parameters[0].Value = model.AMID;
parameters[1].Value = model.BMID;
parameters[2].Value = model.BMBD;
parameters[3].Value = model.BMCreateDate;
parameters[4].Value = model.BMDate;
parameters[5].Value = model.BMState;
parameters[6].Value = model.YJCount;
parameters[7].Value = model.YJMoney;
parameters[8].Value = model.BCount;
parameters[9].Value = model.BIsClock;
parameters[10].Value = model.BOutMoney;
parameters[11].Value = model.FHDays;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Insert(WE_Project.Model.BMember model)
{
//lock (obj)
{
Hashtable MyHs = new Hashtable();
Insert(model, MyHs);
BLL.ChangeMoney.HBChangeTran(model.BCount, model.AMID, BLL.Member.ManageMember.TModel.MID, "FT", null, "MHB", "", MyHs);
if (BLL.CommonBase.RunHashtable(MyHs))
{
return(true);
}
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(WE_Project.Model.BMember model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
string guid = Guid.NewGuid().ToString();
strSql.Append("insert into BMember(");
strSql.Append("AMID,BMID,BMBD,BMCreateDate,BMDate,BMState,BIsClock,YJCount,YJMoney,BCount,BOutMoney,FHDays");
strSql.Append(") values (");
strSql.Append("@AMID,@BMID,@BMBD,@BMCreateDate,@BMDate,@BMState,@BIsClock,@YJCount,@YJMoney,@BCount,@BOutMoney,@FHDays");
strSql.Append(") ");
strSql.AppendFormat("; select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@AMID", SqlDbType.VarChar, 20),
new SqlParameter("@BMID", SqlDbType.VarChar, 20),
new SqlParameter("@BMBD", SqlDbType.VarChar, 20),
new SqlParameter("@BMCreateDate", SqlDbType.DateTime),
new SqlParameter("@BMDate", SqlDbType.DateTime),
new SqlParameter("@BMState", SqlDbType.Bit, 1),
new SqlParameter("@BIsClock", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Decimal),
new SqlParameter("@YJMoney", SqlDbType.Decimal),
new SqlParameter("@BCount", SqlDbType.Decimal),
new SqlParameter("@BOutMoney", SqlDbType.Decimal),
new SqlParameter("@FHDays", SqlDbType.Int, 4)
};
parameters[0].Value = model.AMID;
parameters[1].Value = model.BMID;
parameters[2].Value = model.BMBD;
parameters[3].Value = model.BMCreateDate;
parameters[4].Value = model.BMDate;
parameters[5].Value = model.BMState;
parameters[6].Value = model.BIsClock;
parameters[7].Value = model.YJCount;
parameters[8].Value = model.YJMoney;
parameters[9].Value = model.BCount;
parameters[10].Value = model.BOutMoney;
parameters[11].Value = model.FHDays;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Update(WE_Project.Model.BMember model)
{
return(WE_Project.DAL.BMember.Update(model));
}
public static System.Collections.Hashtable Update(WE_Project.Model.BMember model, System.Collections.Hashtable MyHs)
{
return(WE_Project.DAL.BMember.Update(model, MyHs));
}
public static bool Insert(WE_Project.Model.BMember model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new System.Collections.Hashtable())));
}
