/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemGB entity = (ItemGB)p_BE;
ItemGBCtl control = new ItemGBCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_ItemGB, sqlTrans);
FormNoControlRule rule = new FormNoControlRule();
//entity.GBCode= rule.RGetFormNo((int)FormNoControlEnum.挂板单号);
string sql = "SELECT GBCode FROM Data_ItemGB WHERE GBCode=" + SysString.ToDBString(entity.GBCode);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("挂板条码号已存在，请检查后操作");
}
control.AddNew(entity);
rule.RAddSort((int)FormNoControlEnum.挂板单号, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
private void EntitySet()
{
ItemGB entity = new ItemGB();
entity.ID = m_ID;
entity.SelectByID();
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要修改的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RUpdate(BaseEntity p_BE, int p_ID, int p_Seq, IDBTransAccess sqlTrans)
{
try
{
if (p_Seq == 0)
{
throw new BaseException("挂板数据有问题，请联系管理员");
}
string sql = "DELETE Data_ItemGB WHERE MainID=" + SysString.ToDBString(p_ID);
sql += " AND Seq=" + SysString.ToDBString(p_Seq);
sqlTrans.ExecuteNonQuery(sql);
ItemGBRule rule = new ItemGBRule();
ItemGB entity = (ItemGB)p_BE;
entity.MainID = p_ID;
entity.Seq = p_Seq;
rule.RAdd(entity, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 获取挂板信息实体
/// </summary>
/// <returns></returns>
private ItemGB[] GetItemGB()
{
int Num = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (SysConvert.ToString(gridView1.GetRowCellValue(i, "ColorNum")) != string.Empty)
{
Num++;
}
}
ItemGB[] entitydts = new ItemGB[0];
int index = 0;
for (int i = 0; i < 0; i++)
{
if (SysConvert.ToString(gridView1.GetRowCellValue(i, "ColorNum")) != string.Empty)
{
entitydts[index] = new ItemGB();
entitydts[index].ID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "ID"));
entitydts[index].SelectByID();
entitydts[index].MainID = HTDataID;
entitydts[index].Seq = i + 1;
index++;
}
}
return(entitydts);
}
/// <summary>
/// 保存(传入事务处理)
/// </summary>
/// <param name="p_Entity"></param>
/// <param name="p_BE"></param>
/// <param name="sqlTrans"></param>
public void RSave(Item p_Entity, BaseEntity[] p_BE, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Data_ItemGB WHERE MainID=" + p_Entity.ID.ToString();
sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(p_BE));
sqlTrans.ExecuteNonQuery(sql);//删除原单据里应该删除的明细数据，即数据库里有但是UI里已经删除的数据
for (int i = 0; i < p_BE.Length; i++)
{
ItemGB entitydts = (ItemGB)p_BE[i];
if (entitydts.ID != 0)//ID不为0说明数据库中已经存在
{
this.RUpdate(entitydts, sqlTrans);
}
else
{
entitydts.MainID = p_Entity.ID;
this.RAdd(entitydts, sqlTrans);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, int p_ID, IDBTransAccess sqlTrans)
{
try
{
ItemGBRule rule = new ItemGBRule();
ItemGB entity = (ItemGB)p_BE;
string sql = "SELECT GBCode FROM Data_ItemGB WHERE GBCode=" + SysString.ToDBString(entity.GBCode);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("挂板条码已存在，请重新输入");
}
sql = "SELECT Max(Seq) Seq FROM Data_ItemGB WHERE MainID=" + SysString.ToDBString(p_ID);
dt = sqlTrans.Fill(sql);
int seq = 1;
if (dt.Rows.Count > 0)
{
seq = SysConvert.ToInt32(dt.Rows[0][0]);
}
entity.MainID = p_ID;
entity.Seq = seq + 1;
rule.RAdd(entity, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
ItemGB MasterEntity = (ItemGB)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM Data_ItemGB WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
private void gridViewRowChanged2(object sender)
{
try
{
BaseFocusLabel.Focus();
ColumnView view = sender as ColumnView;
if (view.FocusedRowHandle >= 0)
{
int ID = SysConvert.ToInt32(view.GetRowCellValue(view.FocusedRowHandle, "DtsID"));
ItemGB entityGB = new ItemGB();
entityGB.ID = ID;
entityGB.SelectByID();
List <Image> lstimage = new List <Image>();
if (entityGB.GBPic.Length > 10)
{
lstimage.Add(TemplatePic.ByteToImage(entityGB.GBPic));
}
ucPictureView1.UCDataLstImage = lstimage;
}
else
{
List <Image> lstimage = new List <Image>();
ucPictureView1.UCDataLstImage = lstimage;
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void EntitySet()
{
ItemGB entity = new ItemGB();
entity.ID = m_ID;
entity.SelectByID();
txtGBDesc.Text = entity.GBDesc;
txtDRemark.Text = entity.Remark;
}
private void EntitySet()
{
ItemGB entity = new ItemGB();
entity.ID = m_ID;
entity.SelectByID();
txtGBDesc.Text = entity.GBDesc;
drpXY.EditValue = entity.XY;
txtXYDesc.Text = entity.XYDesc;
txtDRemark.Text = entity.Remark;
}
/// <summary>
/// 获得数据库里没有被删除的ID(即数据库里有而且UI里也没有删除的数据)
/// </summary>
/// <param name="p_BE"></param>
/// <returns></returns>
private string GetIDExist(BaseEntity[] p_BE)
{
string outstr = "0";
for (int i = 0; i < p_BE.Length; i++)
{
ItemGB entitydts = (ItemGB)p_BE[i];
if (entitydts.ID != 0)
{
outstr += "," + entitydts.ID;
}
}
return(outstr);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemGB entity = (ItemGB)p_BE;
ItemGBCtl control = new ItemGBCtl(sqlTrans);
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
private void EntitySet()
{
if (m_DID == 0)
{
Item entity = new Item();
entity.ID = m_ID;
entity.SelectByID();
drpGBDate.DateTime = DateTime.Now.Date;
txtGBItemName.Text = entity.ItemName;
txtGMWeight.Text = entity.MWeight.ToString();
txtGMWidth.Text = entity.MWidth.ToString();
drpGBStatusID.EditValue = (int)EnumGBStatus.在库;
txtGBCode_DoubleClick(null, null);
}
else
{
ItemGB entityGB = new ItemGB();
entityGB.ID = m_DID;
entityGB.SelectByID();
drpGBDate.DateTime = entityGB.GBDate;
List <Image> lstimage = new List <Image>();
if (entityGB.GBPic.Length > 10)
{
lstimage.Add(TemplatePic.ByteToImage(entityGB.GBPic));
ucPictureInput1.UCDataLstImage = lstimage;
}
txtGBCode.Text = entityGB.GBCode;
txtColorNum.Text = entityGB.ColorNum;
txtColorName.Text = entityGB.ColorName;
txtDRemark.Text = entityGB.Remark;
txtGBItemName.Text = entityGB.ItemName;
txtGMWeight.Text = entityGB.MWeight.ToString();
txtGMWidth.Text = entityGB.MWidth.ToString();
drpGBStatusID.EditValue = entityGB.GBStatusID;
}
Common.BindGBColorNum(txtColorNum, m_ID, true);
Common.BindGBColorName(txtColorName, m_ID, true);
}
//private string GetColorName(string p_ColorNum)
//{
// string ColorName = "";
// string sql = "SELECT ColorName FROM Data_ItemColorDts WHERE MainID=" + SysString.ToDBString(m_ID);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// DataTable dt = SysUtils.Fill(sql);
// if (dt.Rows.Count > 0)
// {
// ColorName = SysConvert.ToString(dt.Rows[0][0]);
// }
// return ColorName;
//}
//private string GetColorNum(string p_ColorName)
//{
// string ColorNum = "";
// string sql = "SELECT ColorNum FROM Data_ItemColorDts WHERE MainID=" + SysString.ToDBString(m_ID);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// DataTable dt = SysUtils.Fill(sql);
// if (dt.Rows.Count > 0)
// {
// ColorNum = SysConvert.ToString(dt.Rows[0][0]);
// }
// return ColorNum;
//}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
ItemGBRule rule = new ItemGBRule();
ItemGB entity = GetItemGB();
if (m_DID == 0)
{
rule.RAdd(entity);
m_DID = entity.ID;
}
else
{
rule.RUpdate(entity);
}
this.ShowInfoMessage("保存成功！");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
//private void btnPicNewBrowsing_Click(object sender, EventArgs e)
//{
// try
// {
// if (m_ID == 0)
// {
// this.ShowMessage("请先保存数据");
// return;
// }
// openFileDialog1.Filter = "JPG文件(*.jpg)|*.jpg|GIF文件(*.gif)|*.gif|BMP文件(*.bmp)|*.bmp|全部文件(*.*)|*.*";
// if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
// {
// string filenamerount = openFileDialog1.FileName;
// img1.Image = Image.FromFile(filenamerount);
// }
// }
// catch (Exception E)
// {
// this.ShowMessage(E.Message);
// }
//}
private ItemGB GetItemGB()
{
ItemGB entity = new ItemGB();
entity.ID = m_DID;
entity.SelectByID();
entity.MainID = m_ID;
if (entity.Seq == 0)
{
entity.Seq = GetMaxSeq(m_ID);
}
entity.ColorName = txtColorName.Text.Trim();
entity.ColorNum = txtColorNum.Text.Trim();
entity.GBCode = txtGBCode.Text.Trim();
entity.XY = SysConvert.ToInt32(drpXY.EditValue);
entity.GBStatusID = SysConvert.ToInt32(drpGBStatusID.EditValue);
if (ucPictureInput1.UCDataLstImage.Count > 0)
{
entity.GBPic = TemplatePic.ImageToByte(ucPictureInput1.UCDataLstImage[0]);
if (ucPictureInput1.UCDataLstSmallImage.Count > 0)
{
entity.GBPic2 = TemplatePic.ImageToByte(ucPictureInput1.UCDataLstSmallImage[0]);
}
}
else
{
entity.GBPic = new byte[2];
entity.GBPic2 = new byte[2];
}
entity.Remark = txtDRemark.Text.Trim();
entity.GBDate = drpGBDate.DateTime.Date;
entity.MWidth = txtGMWidth.Text.Trim();
entity.MWeight = txtGMWeight.Text.Trim();
entity.ItemName = txtGBItemName.Text.Trim();
return(entity);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ItemGB MasterEntity = (ItemGB)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Data_ItemGB(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("MainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ",");
MasterField.Append("Seq" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ",");
MasterField.Append("GBCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GBCode) + ",");
MasterField.Append("GBDate" + ",");
if (MasterEntity.GBDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.GBDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ColorNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorNum) + ",");
MasterField.Append("ColorName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorName) + ",");
MasterField.Append("GBDesc" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GBDesc) + ",");
MasterField.Append("XY" + ",");
if (MasterEntity.XY != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.XY) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("XYDesc" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.XYDesc) + ",");
MasterField.Append("GBPic" + ",");
MasterValue.Append(@"@GBPic" + ",");
MasterField.Append("GBPic2" + ",");
MasterValue.Append(@"@GBPic2" + ",");
MasterField.Append("GBStatusID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GBStatusID) + ",");
MasterField.Append("Remark" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ",");
MasterField.Append("GBFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GBFlag) + ",");
MasterField.Append("MWidth" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWidth) + ",");
MasterField.Append("MWeight" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWeight) + ",");
MasterField.Append("WeightUnit" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WeightUnit) + ",");
MasterField.Append("testReportFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.testReportFlag) + ",");
MasterField.Append("testReportNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.testReportNum) + ",");
MasterField.Append("ItemName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemName) + ",");
MasterField.Append("PMainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PMainID) + ",");
MasterField.Append("PItemName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PItemName) + ",");
MasterField.Append("XYDescRemark" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.XYDescRemark) + ",");
MasterField.Append("GBPrice" + ",");
if (MasterEntity.GBPrice != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.GBPrice) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Unit" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.Unit) + ")");
object[,] obja = new object[2, 2];
obja[0, 0] = "@GBPic";
obja[1, 0] = MasterEntity.GBPic;
obja[0, 1] = "@GBPic2";
obja[1, 1] = MasterEntity.GBPic2;
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
ItemGB entity = (ItemGB)p_BE;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
ItemGB MasterEntity = (ItemGB)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Data_ItemGB SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" GBCode=" + SysString.ToDBString(MasterEntity.GBCode) + ",");
if (MasterEntity.GBDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" GBDate=" + SysString.ToDBString(MasterEntity.GBDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" GBDate=null,");
}
UpdateBuilder.Append(" ColorNum=" + SysString.ToDBString(MasterEntity.ColorNum) + ",");
UpdateBuilder.Append(" ColorName=" + SysString.ToDBString(MasterEntity.ColorName) + ",");
UpdateBuilder.Append(" GBDesc=" + SysString.ToDBString(MasterEntity.GBDesc) + ",");
if (MasterEntity.XY != 0)
{
UpdateBuilder.Append(" XY=" + SysString.ToDBString(MasterEntity.XY) + ",");
}
else
{
UpdateBuilder.Append(" XY=null,");
}
UpdateBuilder.Append(" XYDesc=" + SysString.ToDBString(MasterEntity.XYDesc) + ",");
UpdateBuilder.Append(" GBPic=@GBPic" + ",");
UpdateBuilder.Append(" GBPic2=@GBPic2" + ",");
UpdateBuilder.Append(" GBStatusID=" + SysString.ToDBString(MasterEntity.GBStatusID) + ",");
UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ",");
UpdateBuilder.Append(" GBFlag=" + SysString.ToDBString(MasterEntity.GBFlag) + ",");
UpdateBuilder.Append(" MWidth=" + SysString.ToDBString(MasterEntity.MWidth) + ",");
UpdateBuilder.Append(" MWeight=" + SysString.ToDBString(MasterEntity.MWeight) + ",");
UpdateBuilder.Append(" WeightUnit=" + SysString.ToDBString(MasterEntity.WeightUnit) + ",");
UpdateBuilder.Append(" testReportFlag=" + SysString.ToDBString(MasterEntity.testReportFlag) + ",");
UpdateBuilder.Append(" testReportNum=" + SysString.ToDBString(MasterEntity.testReportNum) + ",");
UpdateBuilder.Append(" ItemName=" + SysString.ToDBString(MasterEntity.ItemName) + ",");
UpdateBuilder.Append(" PMainID=" + SysString.ToDBString(MasterEntity.PMainID) + ",");
UpdateBuilder.Append(" PItemName=" + SysString.ToDBString(MasterEntity.PItemName) + ",");
UpdateBuilder.Append(" XYDescRemark=" + SysString.ToDBString(MasterEntity.XYDescRemark) + ",");
if (MasterEntity.GBPrice != 0)
{
UpdateBuilder.Append(" GBPrice=" + SysString.ToDBString(MasterEntity.GBPrice) + ",");
}
else
{
UpdateBuilder.Append(" GBPrice=null,");
}
UpdateBuilder.Append(" Unit=" + SysString.ToDBString(MasterEntity.Unit));
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
object[,] obja = new object[2, 2];
obja[0, 0] = "@GBPic";
obja[1, 0] = MasterEntity.GBPic;
obja[0, 1] = "@GBPic2";
obja[1, 1] = MasterEntity.GBPic2;
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString(), obja);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString(), obja);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
