public HandlingResult Add(SnModel model)
{
HandlingResult result = new HandlingResult();
String querysql = String.Format("SELECT COUNT(1) AS CNT FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code);
String sql =
"INSERT INTO BPSYS_STORESN(ID, STOREID, NAME, CODE, STATUS, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}', '{2}', '{3}', {4}, '{5}', '{6}', '{7}')";
sql = String.Format(sql, model.Id, model.StoreId, model.Name, model.Code, 1,
UserInformationContext.LoginName,
UserInformationContext.ID, DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL));
using (DataBaseProcess process = new DataBaseProcess())
{
DataTable dt = process.Query(querysql);
if (dt != null && dt.Rows.Count > 0)
{
result.MsgNumber = Int32.Parse(dt.Rows[0]["CNT"].ToString());
if (result.MsgNumber == 0)
{
result.MsgNumber = process.Exec(sql);
}
else
{
result.MsgNumber = 0;
result.Message = String.Format("SN[{0}]已经存在", model.Code);
}
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "新增成功" : "新增失败";
return result;
}
public HandlingResult Update(SnModel model)
{
HandlingResult result = new HandlingResult();
String sql = String.Format("UPDATE BPSYS_STORESN SET NAME='{0}',CODE='{1}' WHERE ID='{2}'", model.Name,
model.Code, model.Id);
String querysql = String.Format("SELECT ID FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code);
using (DataBaseProcess process = new DataBaseProcess())
{
DataTable dt = process.Query(querysql);
if (dt != null && dt.Rows.Count > 0)
{
Guid id = Guid.Parse(dt.Rows[0]["ID"].ToString());
if (id != model.Id)
{
result.MsgNumber = 0;
result.Message = String.Format("SN[{0}]已经存在", model.Code);
}
else
{
result.MsgNumber = process.Exec(sql);
}
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Message.Length > 0 ? result.Message : result.Successed ? "更新成功" : "更新失败";
return result;
}
private HandlingResult ValidateSNSave()
{
HandlingResult result = new HandlingResult();
SnModel model = new SnModel();
model.Name = textBoxSnName.Text.TrimStart().TrimEnd();
model.Code = textBoxSnCode.Text.TrimStart().TrimEnd();
model.StoreId = _selStoreId;
if (String.IsNullOrEmpty(model.Name))
{
result.Successed = false;
result.Message += "\r\n请填写SN别名";
}
if (String.IsNullOrEmpty(model.Code))
{
result.Successed = false;
result.Message += "\r\n请填写SN";
}
if (model.StoreId==null || model.StoreId.Equals(Guid.Empty))
{
result.Successed = false;
result.Message += "\r\n请选择门店";
}
model.Id = Guid.NewGuid();
result.Result = model;
return result;
}