/// <summary>
/// 得到一个对象实体
/// </summary>
public Cao.WMS.Model.caowms.Warehouses DataRowToModel(DataRow row)
{
Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses();
if (row != null)
{
if (row["WID"] != null && row["WID"].ToString() != "")
{
model.WID = row["WID"].ToString();
}
if (row["WName"] != null)
{
model.WName = row["WName"].ToString();
}
if (row["WArea"] != null && row["WArea"].ToString() != "")
{
model.WArea = decimal.Parse(row["WArea"].ToString());
}
if (row["WAddress"] != null)
{
model.WAddress = row["WAddress"].ToString();
}
if (row["WDescribe"] != null)
{
model.WDescribe = row["WDescribe"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Cao.WMS.Model.caowms.Warehouses model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Warehouses(");
strSql.Append("WID,WName,WArea,WAddress,WDescribe)");
strSql.Append(" values (");
strSql.Append("@WID,@WName,@WArea,@WAddress,@WDescribe)");
SqlParameter[] parameters =
{
new SqlParameter("@WID", SqlDbType.NVarChar, 50),
new SqlParameter("@WName", SqlDbType.NVarChar, 50),
new SqlParameter("@WArea", SqlDbType.Float, 8),
new SqlParameter("@WAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@WDescribe", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.WID;
parameters[1].Value = model.WName;
parameters[2].Value = model.WArea;
parameters[3].Value = model.WAddress;
parameters[4].Value = model.WDescribe;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(string WID)
{
Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses();
Cao.WMS.Model.caowms.Warehouses model = bll.GetModel(WID);
this.lblWID.Text = model.WID.ToString();
this.lblWName.Text = model.WName;
this.lblWArea.Text = model.WArea.ToString();
this.lblWAddress.Text = model.WAddress;
this.lblWDescribe.Text = model.WDescribe;
}
/// <summary>
///新增仓库货位
/// </summary>
public void addWarehouses()
{
bool addWarehouses = true;
Cao.WMS.BLL.caowms.Warehouses bllWarehouses = new Cao.WMS.BLL.caowms.Warehouses();
addWarehouses = bllWarehouses.Exists(this.txtRWID.Text);
if (!addWarehouses)
{
Cao.WMS.Model.caowms.Warehouses modelWarehouses = new Cao.WMS.Model.caowms.Warehouses();
modelWarehouses.WID = this.txtRWID.Text;
modelWarehouses.WName = "";
modelWarehouses.WArea = 0;
modelWarehouses.WAddress = "";
modelWarehouses.WDescribe = "入库新增货位";
bllWarehouses.Add(modelWarehouses);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtWName.Text.Trim().Length == 0)
{
strErr += "仓库名称不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtWArea.Text))
{
strErr += "仓库容积格式错误！\\n";
}
if (this.txtWAddress.Text.Trim().Length == 0)
{
strErr += "仓库地址不能为空！\\n";
}
if (this.txtWDescribe.Text.Trim().Length == 0)
{
strErr += "简单描述不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string WID = this.lblWID.Text;
string WName = this.txtWName.Text;
decimal WArea = decimal.Parse(this.txtWArea.Text);
string WAddress = this.txtWAddress.Text;
string WDescribe = this.txtWDescribe.Text;
Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses();
model.WID = WID;
model.WName = WName;
model.WArea = WArea;
model.WAddress = WAddress;
model.WDescribe = WDescribe;
Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体WCode
/// </summary>
public Cao.WMS.Model.caowms.Warehouses GetModel(string WID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WID,WName,WArea,WAddress,WDescribe from Warehouses ");
strSql.Append(" where WID=@WID ");
SqlParameter[] parameters =
{
new SqlParameter("@WID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = WID;
Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses();
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 bool Update(Cao.WMS.Model.caowms.Warehouses model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Warehouses set ");
strSql.Append("WName=@WName,");
strSql.Append("WArea=@WArea,");
strSql.Append("WAddress=@WAddress,");
strSql.Append("WDescribe=@WDescribe");
strSql.Append(" where WID=@WID ");
SqlParameter[] parameters =
{
new SqlParameter("@WName", SqlDbType.NVarChar, 50),
new SqlParameter("@WArea", SqlDbType.Float, 8),
new SqlParameter("@WAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@WDescribe", SqlDbType.NVarChar, 500),
new SqlParameter("@WID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.WName;
parameters[1].Value = model.WArea;
parameters[2].Value = model.WAddress;
parameters[3].Value = model.WDescribe;
parameters[4].Value = model.WID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
//if(!PageValidate.IsNumber(txtWID.Text))
//{
// strErr+="仓库编号格式错误！\\n";
//}
if (this.txtWName.Text.Trim().Length == 0)
{
strErr += "仓库名称不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtWArea.Text))
{
strErr += "仓库容积格式错误！\\n";
}
if (this.txtWAddress.Text.Trim().Length == 0)
{
strErr += "仓库地址不能为空！\\n";
}
if (this.txtWDescribe.Text.Trim().Length == 0)
{
strErr += "简单描述不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
bool addWarehouses = true;
Cao.WMS.BLL.caowms.Warehouses bllWarehouses = new Cao.WMS.BLL.caowms.Warehouses();
addWarehouses = bllWarehouses.Exists(this.txtWID.Text.Trim());
if (!addWarehouses)
{
strErr += "编码重复\\n";
MessageBox.Show(this, strErr);
return;
}
bool addWarehousesWName = true;
addWarehousesWName = bllWarehouses.ExistsWName(this.txtWName.Text.Trim());
if (!addWarehouses)
{
strErr += "仓库名称重复\\n";
MessageBox.Show(this, strErr);
return;
}
//int WID=int.Parse(this.txtWID.Text);
string WID = this.txtWID.Text;
string WName = this.txtWName.Text;
decimal WArea = decimal.Parse(this.txtWArea.Text);
string WAddress = this.txtWAddress.Text;
string WDescribe = this.txtWDescribe.Text;
Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses();
model.WID = WID;
model.WName = WName;
model.WArea = WArea;
model.WAddress = WAddress;
model.WDescribe = WDescribe;
Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
