/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.ConsumableStorage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_ConsumableStorage(");
strSql.Append("C_Barcode,Count,UserName,Datetime,Remarks)");
strSql.Append(" values (");
strSql.Append("@C_Barcode,@Count,@UserName,@Datetime,@Remarks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@C_Barcode", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@Datetime", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.Text)
};
parameters[0].Value = model.C_Barcode;
parameters[1].Value = model.Count;
parameters[2].Value = model.UserName;
parameters[3].Value = model.Datetime;
parameters[4].Value = model.Remarks;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ConsumableStorage DataRowToModel(DataRow row)
{
Maticsoft.Model.ConsumableStorage model = new Maticsoft.Model.ConsumableStorage();
if (row != null)
{
if (row["C_StoID"] != null && row["C_StoID"].ToString() != "")
{
model.C_StoID = decimal.Parse(row["C_StoID"].ToString());
}
if (row["C_Barcode"] != null)
{
model.C_Barcode = row["C_Barcode"].ToString();
}
if (row["Count"] != null && row["Count"].ToString() != "")
{
model.Count = int.Parse(row["Count"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["Datetime"] != null)
{
model.Datetime = row["Datetime"].ToString();
}
if (row["Remarks"] != null)
{
model.Remarks = row["Remarks"].ToString();
}
}
return(model);
}
private void ShowInfo(decimal C_StoID)
{
Maticsoft.BLL.ConsumableStorage bll = new Maticsoft.BLL.ConsumableStorage();
Maticsoft.Model.ConsumableStorage model = bll.GetModel(C_StoID);
this.lblC_StoID.Text = model.C_StoID.ToString();
this.lblC_Barcode.Text = model.C_Barcode;
this.lblCount.Text = model.Count.ToString();
this.lblUserName.Text = model.UserName;
this.lblDatetime.Text = model.Datetime;
this.lblRemarks.Text = model.Remarks;
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtC_Barcode.Text.Trim().Length == 0)
{
strErr += "C_Barcode不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCount.Text))
{
strErr += "Count格式错误！\\n";
}
if (this.txtUserName.Text.Trim().Length == 0)
{
strErr += "UserName不能为空！\\n";
}
if (this.txtDatetime.Text.Trim().Length == 0)
{
strErr += "Datetime不能为空！\\n";
}
if (this.txtRemarks.Text.Trim().Length == 0)
{
strErr += "Remarks不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
decimal C_StoID = decimal.Parse(this.lblC_StoID.Text);
string C_Barcode = this.txtC_Barcode.Text;
int Count = int.Parse(this.txtCount.Text);
string UserName = this.txtUserName.Text;
string Datetime = this.txtDatetime.Text;
string Remarks = this.txtRemarks.Text;
Maticsoft.Model.ConsumableStorage model = new Maticsoft.Model.ConsumableStorage();
model.C_StoID = C_StoID;
model.C_Barcode = C_Barcode;
model.Count = Count;
model.UserName = UserName;
model.Datetime = Datetime;
model.Remarks = Remarks;
Maticsoft.BLL.ConsumableStorage bll = new Maticsoft.BLL.ConsumableStorage();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 保存入库记录 并更改库存
/// </summary>
/// <param name="lis"></param>
private int Add_Stotage(DataGrid _Grid)
{
ConsumableStorage _M_ConsumableReceive = new ConsumableStorage();
int _recode = 0;
foreach (object tem in _Grid.ItemsSource)
{
Maticsoft.Model.ConsumableStorage _tem = (Maticsoft.Model.ConsumableStorage)tem;
_tem.Datetime = DateTime.Now.ToString();
if (_M_ConsumableReceive.Add(_tem) > 0)
{
_recode++;
}
}
return(_recode);
}
//
//添加
//
private void btn_Add_Click(object sender, RoutedEventArgs e)
{
Maticsoft.Model.ConsumableReceive _Receive = new Maticsoft.Model.ConsumableReceive();
// _Receive = (Maticsoft.Model.ConsumableReceive)dgv_ConsumableList.DataContext;
Maticsoft.Model.ConsumableStorage _Storage = new Maticsoft.Model.ConsumableStorage();
// _Storage = (Maticsoft.Model.ConsumableStorage)dgv_ConsumableList.DataContext;
bool IsOk = true;
MCP_CS.CheckTextBoxNotNull(ref IsOk, txb_Consumable_Barcode, txb_R_Count, txb_R_Remaks, txb_R_UserID, txb_R_UserName);
if (IsOk)
{
if (_ConsumOperation.Operation == Maticsoft.BLL.cls_Consumable.ConsumableOperation.Receive)
{
_Receive.C_Barcode = txb_Consumable_Barcode.Text.Trim();
_Receive.C_Name = txb_ConsumableName.Text.Trim();
_Receive.Datetime = DateTime.Now.ToString();
_Receive.Count = int.Parse(txb_R_Count.Text.Trim());
_Receive.UserName = txb_R_UserName.Text.Trim();
_Receive.Remarks = txb_R_Remaks.Text.Trim();
_dataList_Receive.Add(_Receive);
}
else
{
_Storage.C_Barcode = txb_Consumable_Barcode.Text.Trim();
_Storage.C_Name = txb_ConsumableName.Text.Trim();
_Storage.Datetime = DateTime.Now.ToString();
_Storage.Count = int.Parse(txb_R_Count.Text.Trim());
_Storage.UserName = txb_R_UserName.Text.Trim();
_Storage.Remarks = txb_R_Remaks.Text.Trim();
_dataList_Storage.Add(_Storage);
}
//
txb_R_Count.Text = "";
txb_Consumable_Barcode.Text = "";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.ConsumableStorage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_ConsumableStorage set ");
strSql.Append("C_Barcode=@C_Barcode,");
strSql.Append("Count=@Count,");
strSql.Append("UserName=@UserName,");
strSql.Append("Datetime=@Datetime,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where C_StoID=@C_StoID");
SqlParameter[] parameters =
{
new SqlParameter("@C_Barcode", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@Datetime", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.Text),
new SqlParameter("@C_StoID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.C_Barcode;
parameters[1].Value = model.Count;
parameters[2].Value = model.UserName;
parameters[3].Value = model.Datetime;
parameters[4].Value = model.Remarks;
parameters[5].Value = model.C_StoID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ConsumableStorage GetModel(decimal C_StoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 C_StoID,C_Barcode,Count,UserName,Datetime,Remarks from tb_ConsumableStorage ");
strSql.Append(" where C_StoID=@C_StoID");
SqlParameter[] parameters =
{
new SqlParameter("@C_StoID", SqlDbType.Decimal)
};
parameters[0].Value = C_StoID;
Maticsoft.Model.ConsumableStorage model = new Maticsoft.Model.ConsumableStorage();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}