/// <summary>
/// 更新数据
/// 作者：章建国
/// </summary>
/// <param name="model">需要更新的模型</param>
/// <returns></returns>
private string UpdateEasyConsumeIN(tb_EasyConsumeIN model, string flag)
{
try
{
if (model != null && model.id > 0)
{
model.updateDate = DateTime.Now;
model.updateUser = CurrentUserInfo.PersonnelID;
var tempinmodel = _easyconsumeinbll.GetModel(model.id);
var devicemodel = _easyconsumebll.GetModel(model.eId.Value);
if (_easyconsumeinbll.Update(model))
{
if (model.amount > tempinmodel.amount)
{
devicemodel.amount += model.amount - tempinmodel.amount;
}
else if (model.amount < tempinmodel.amount)
{
devicemodel.amount -= tempinmodel.amount - model.amount;
}
if (_easyconsumebll.Update(devicemodel))
{
flag = "1";
}
}
}
}
catch
{
flag = "0";
}
return(flag);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_EasyConsumeIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_EasyConsumeIN(");
strSql.Append("eId,inDate,price,amount,inMoney,product,user1,remark,createUser,createDate,updateUser,updateDate,temp1,temp2,productDate,validDate,manufacturers,GPS)");
strSql.Append(" values (");
strSql.Append("@eId,@inDate,@price,@amount,@inMoney,@product,@user1,@remark,@createUser,@createDate,@updateUser,@updateDate,@temp1,@temp2,@productDate,@validDate,@manufacturers,@GPS)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@eId", SqlDbType.Int, 4),
new SqlParameter("@inDate", SqlDbType.DateTime),
new SqlParameter("@price", SqlDbType.Decimal, 9),
new SqlParameter("@amount", SqlDbType.Int, 4),
new SqlParameter("@inMoney", SqlDbType.Decimal, 9),
new SqlParameter("@product", SqlDbType.NVarChar, -1),
new SqlParameter("@user1", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@createUser", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@updateUser", SqlDbType.Int, 4),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@temp1", SqlDbType.NVarChar, -1),
new SqlParameter("@temp2", SqlDbType.NVarChar, -1),
new SqlParameter("@productDate", SqlDbType.DateTime),
new SqlParameter("@validDate", SqlDbType.DateTime),
new SqlParameter("@manufacturers", SqlDbType.NVarChar, 500),
new SqlParameter("@GPS", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.eId;
parameters[1].Value = model.inDate;
parameters[2].Value = model.price;
parameters[3].Value = model.amount;
parameters[4].Value = model.inMoney;
parameters[5].Value = model.product;
parameters[6].Value = model.user1;
parameters[7].Value = model.remark;
parameters[8].Value = model.createUser;
parameters[9].Value = model.createDate;
parameters[10].Value = model.updateUser;
parameters[11].Value = model.updateDate;
parameters[12].Value = model.temp1;
parameters[13].Value = model.temp2;
parameters[14].Value = model.productDate;
parameters[15].Value = model.validDate;
parameters[16].Value = model.manufacturers;
parameters[17].Value = model.GPS;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
public DataTable GetEasyConsumeLogListByPage(Model.PersonnelManage.E_tb_InPersonnel CurrentUserInfo, int _cid, string _searchtext, string orderby, int startIndex, int endIndex, string _searchtext2)
{
String where2 = "";
if (!String.IsNullOrEmpty(_searchtext2))
{
where2 = " name like '%%" + _searchtext2 + "%%'";
}
DataTable dt = dal.GetListByPage(where2, orderby, startIndex, endIndex).Tables[0];
tb_EasyConsumeOUTBLL _outbll = new tb_EasyConsumeOUTBLL();
tb_EasyConsumeINBLL _inbll = new tb_EasyConsumeINBLL();
dt.Columns.Add("ruku");
dt.Columns.Add("chuku");
for (int i = 0; i < dt.Rows.Count; i++)
{
int eid = Convert.ToInt32(dt.Rows[i]["id"]);
string where = " 1 = 1 ";
if (!string.IsNullOrEmpty(_searchtext))
{
where += string.Format(" and (cast(OutDate as datetime)) = '{0}' ", _searchtext);
}
if (CurrentUserInfo.DataRange == 3)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", CurrentUserInfo.AreaID.Value, _userid);
}
else if (_cid > 0 || CurrentUserInfo.DataRange == 2)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid);
}
where += " and eid=" + eid;
DataTable dtout = _outbll.GetEasyCOnsumeOUTSUMForLog(where);
if (dtout != null && dtout.Rows.Count > 0)
{
int inid = Convert.ToInt32(dtout.Rows[0]["temp2"]);
tb_EasyConsumeIN inmodel = _inbll.GetModel(inid);
dt.Rows[i]["chuku"] = dtout.Rows[0]["chuku"];
dt.Rows[i]["ruku"] = inmodel.amount;
dt.Rows[i]["amount"] = inmodel.temp2;
}
}
return(dt);
}
/// <summary>
/// 新建数据
/// 作者：章建国
/// </summary>
/// <param name="model"></param>
/// <param name="flag"></param>
/// <returns></returns>
private string NewEasyConsumeIN(tb_EasyConsumeIN model, string flag)
{
model.createDate = DateTime.Now;
model.createUser = CurrentUserInfo.PersonnelID;
model.updateDate = DateTime.Now;
model.updateUser = CurrentUserInfo.PersonnelID;
var devicemodel = _easyconsumebll.GetModel(model.eId.Value);
if (_easyconsumeinbll.Add(model) > 0)
{
devicemodel.amount += model.amount;
if (_easyconsumebll.Update(devicemodel))
{
flag = "1";
}
}
return(flag);
}
/// <summary>
/// 新建数据或更新数据
/// 作者：章建国
/// </summary>
/// <param name="model">新输入的数据</param>
/// <returns></returns>
public string EasyConsumeINCU(tb_EasyConsumeIN model)
{
string flag = "0";
try
{
if (model.id > 0)
{
flag = UpdateEasyConsumeIN(model, flag);
}
else
{
model.temp2 = model.amount.Value.ToString();
flag = NewEasyConsumeIN(model, flag);
}
}
catch
{
flag = "0";
}
return(flag);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tb_EasyConsumeIN GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_easyconsumein");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
tb_EasyConsumeIN model = new tb_EasyConsumeIN();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tb_EasyConsumeIN DataRowToModel(DataRow row)
{
tb_EasyConsumeIN model = new tb_EasyConsumeIN();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["eId"] != null && row["eId"].ToString() != "")
{
model.eId = int.Parse(row["eId"].ToString());
}
if (row["inDate"] != null && row["inDate"].ToString() != "")
{
model.inDate = DateTime.Parse(row["inDate"].ToString());
}
if (row["price"] != null && row["price"].ToString() != "")
{
model.price = decimal.Parse(row["price"].ToString());
}
if (row["amount"] != null && row["amount"].ToString() != "")
{
model.amount = int.Parse(row["amount"].ToString());
}
if (row["inMoney"] != null && row["inMoney"].ToString() != "")
{
model.inMoney = decimal.Parse(row["inMoney"].ToString());
}
if (row["product"] != null)
{
model.product = row["product"].ToString();
}
if (row["user1"] != null && row["user1"].ToString() != "")
{
model.user1 = int.Parse(row["user1"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createUser"] != null && row["createUser"].ToString() != "")
{
model.createUser = int.Parse(row["createUser"].ToString());
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["updateUser"] != null && row["updateUser"].ToString() != "")
{
model.updateUser = int.Parse(row["updateUser"].ToString());
}
if (row["updateDate"] != null && row["updateDate"].ToString() != "")
{
model.updateDate = DateTime.Parse(row["updateDate"].ToString());
}
if (row["temp1"] != null)
{
model.temp1 = row["temp1"].ToString();
}
if (row["temp2"] != null)
{
model.temp2 = row["temp2"].ToString();
}
if (row["productDate"] != null && row["productDate"].ToString() != "")
{
model.productDate = DateTime.Parse(row["productDate"].ToString());
}
if (row["validDate"] != null && row["validDate"].ToString() != "")
{
model.validDate = DateTime.Parse(row["validDate"].ToString());
}
if (row["manufacturers"] != null)
{
model.manufacturers = row["manufacturers"].ToString();
}
if (row["GPS"] != null)
{
model.GPS = row["GPS"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_EasyConsumeIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_EasyConsumeIN set ");
strSql.Append("eId=@eId,");
strSql.Append("inDate=@inDate,");
strSql.Append("price=@price,");
strSql.Append("amount=@amount,");
strSql.Append("inMoney=@inMoney,");
strSql.Append("product=@product,");
strSql.Append("user1=@user1,");
strSql.Append("remark=@remark,");
strSql.Append("createUser=@createUser,");
strSql.Append("createDate=@createDate,");
strSql.Append("updateUser=@updateUser,");
strSql.Append("updateDate=@updateDate,");
strSql.Append("temp1=@temp1,");
strSql.Append("temp2=@temp2,");
strSql.Append("productDate=@productDate,");
strSql.Append("validDate=@validDate,");
strSql.Append("manufacturers=@manufacturers,");
strSql.Append("GPS=@GPS");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@eId", SqlDbType.Int, 4),
new SqlParameter("@inDate", SqlDbType.DateTime),
new SqlParameter("@price", SqlDbType.Decimal, 9),
new SqlParameter("@amount", SqlDbType.Int, 4),
new SqlParameter("@inMoney", SqlDbType.Decimal, 9),
new SqlParameter("@product", SqlDbType.NVarChar, -1),
new SqlParameter("@user1", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@createUser", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@updateUser", SqlDbType.Int, 4),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@temp1", SqlDbType.NVarChar, -1),
new SqlParameter("@temp2", SqlDbType.NVarChar, -1),
new SqlParameter("@productDate", SqlDbType.DateTime),
new SqlParameter("@validDate", SqlDbType.DateTime),
new SqlParameter("@manufacturers", SqlDbType.NVarChar, 500),
new SqlParameter("@GPS", SqlDbType.NVarChar, -1),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.eId;
parameters[1].Value = model.inDate;
parameters[2].Value = model.price;
parameters[3].Value = model.amount;
parameters[4].Value = model.inMoney;
parameters[5].Value = model.product;
parameters[6].Value = model.user1;
parameters[7].Value = model.remark;
parameters[8].Value = model.createUser;
parameters[9].Value = model.createDate;
parameters[10].Value = model.updateUser;
parameters[11].Value = model.updateDate;
parameters[12].Value = model.temp1;
parameters[13].Value = model.temp2;
parameters[14].Value = model.productDate;
parameters[15].Value = model.validDate;
parameters[16].Value = model.manufacturers;
parameters[17].Value = model.GPS;
parameters[18].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_EasyConsumeIN model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_EasyConsumeIN model)
{
return(dal.Add(model));
}
public JsonResult GetEasyConsumeINModel(int _id)
{
tb_EasyConsumeIN model = _easyconsumeinbll.GetModel(_id);
return(Json(model, JsonRequestBehavior.AllowGet));
}
