public MixMaterialGroup_mmpg_Info DisplayRecord(IModelObject KeyObject)
{
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialGroup_mmpg disTab = db.MixMaterialGroup_mmpg.SingleOrDefault(t => t.mmpg_Id == ((KeyObject) as MixMaterialGroup_mmpg_Info).mmpg_Id);
if (disTab != null)
{
info = Common.General.CopyObjectValue<MixMaterialGroup_mmpg, MixMaterialGroup_mmpg_Info>(disTab);
}
}
return info;
}
public bool InsertRecord(MixMaterialGroup_mmpg_Info infoObject)
{
bool isSuccess = false;
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
info = infoObject;
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialGroup_mmpg newTab = Common.General.CopyObjectValue<MixMaterialGroup_mmpg_Info, MixMaterialGroup_mmpg>(infoObject);
db.MixMaterialGroup_mmpg.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
return isSuccess;
}
public bool DeleteRecord(IModelObject KeyObject)
{
bool isSuccess = false;
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
info = KeyObject as MixMaterialGroup_mmpg_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialGroup_mmpg delTab = db.MixMaterialGroup_mmpg.SingleOrDefault(t => t.mmpg_Id == info.mmpg_Id);
if (delTab != null)
{
db.MixMaterialGroup_mmpg.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
public ReturnValueInfo Save_SQL(IModelObject itemEntity, DefineConstantValue.EditStateEnum EditMode)
{
ReturnValueInfo returnValue = new ReturnValueInfo();
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
returnValue.messageText = "";
info = itemEntity as MixMaterialGroup_mmpg_Info;
try
{
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
bool isExist = false;
isExist = _MixMaterialGroupSQL.IsExistRecord(info);
if (!isExist)
{
returnValue.boolValue = _MixMaterialGroupSQL.InsertRecord(info);
}
else
{
returnValue.boolValue = false;
returnValue.messageText = "數據重複!";
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
returnValue.boolValue = _MixMaterialGroupSQL.UpdateRecord(info);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
returnValue.boolValue = _MixMaterialGroupSQL.DeleteRecord(info);
break;
}
}
catch (Exception Ex)
{
throw Ex;
}
return returnValue;
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
BindData();
if (this.EditState == Common.DefineConstantValue.EditStateEnum.OE_Insert)
{
this.TabText = "新增 - " + this.Text;
//this._tmpobjInfo = new MaterialProfile_mlpf_Info();
this.sysToolBar.BtnSave_IsUsed = true;
this.sysToolBar.BtnSave_IsEnabled = true;
}
else if (this.EditState == Common.DefineConstantValue.EditStateEnum.OE_Update)
{
this.TabText = "编辑 - " + this.Text;
if (base.BaseParam != null)
{
MixMaterialGroup_mmpg_Info objInfo = this.BaseParam as MixMaterialGroup_mmpg_Info;
this._tmpGroup = objInfo;
txtCode.Enabled = false;
txtCode.Text = this._tmpGroup.mmpg_cMaterialGroupNo;
txtName.Text = this._tmpGroup.mmpg_cMaterialGroupName;
ShowDetail();
}
else
{
this.ShowWarningMessage("没有可用的记录。");
}
this.sysToolBar.BtnSave_IsUsed = true;
this.sysToolBar.BtnSave_IsEnabled = true;
}
else if (this.EditState == Common.DefineConstantValue.EditStateEnum.OE_ReaOnly)
{
this.TabText = "查看 - " + this.Text;
if (base.BaseParam != null)
{
MixMaterialGroup_mmpg_Info objInfo = this.BaseParam as MixMaterialGroup_mmpg_Info;
this._tmpGroup = objInfo;
txtCode.Text = this._tmpGroup.mmpg_cMaterialGroupNo;
txtName.Text = this._tmpGroup.mmpg_cMaterialGroupName;
ShowDetail();
}
else
{
this.ShowWarningMessage("没有可用的记录。");
}
this.sysToolBar.BtnSave_IsUsed = false;
}
this.sysToolBar.BtnExit_IsEnabled = true;
this.sysToolBar.BtnExit_IsUsed = true;
this.sysToolBar.BtnDelete_IsEnabled = false;
//btnAdd.Enabled = false;
btnSave.Enabled = false;
SetLV(lstViewMaterial, true);
SetLV(lstViewGroupDetail, false);
}
void GetObjInfo()
{
_tmpDetail = new List<MixMaterialDetail_mmdl_Info>();
if (this.EditState == Common.DefineConstantValue.EditStateEnum.OE_Insert)
{
_tmpGroup = new MixMaterialGroup_mmpg_Info() { mmpg_Id = Guid.NewGuid() };
_tmpGroup.mmpg_cAdd = base.UserInformation.usm_cUserLoginID;
_tmpGroup.mmpg_dAddDate = DateTime.Now;
_tmpGroup.mmpg_cLast = base.UserInformation.usm_cUserLoginID;
_tmpGroup.mmpg_dLastDate = DateTime.Now;
}
_tmpGroup.mmpg_cMaterialGroupNo = txtCode.Text;
_tmpGroup.mmpg_cMaterialGroupName = txtName.Text;
if (lstViewGroupDetail.Items.Count > 0)
{
MixMaterialDetail_mmdl_Info tmpDetail;
foreach (ListViewItem item in lstViewGroupDetail.Items)
{
tmpDetail = new MixMaterialDetail_mmdl_Info() { mmdl_Id = Guid.NewGuid() };
tmpDetail.mmdl_cMaterialGroupNo = txtCode.Text;
tmpDetail.mmdl_cMaterialCode = item.SubItems[2].Text;
tmpDetail.mmdl_fMaterialProportion = Convert.ToDecimal(item.SubItems[1].Text);
_tmpDetail.Add(tmpDetail);
}
}
}
/// <summary>
/// 物料群組主檔
/// </summary>
public List<MixMaterialGroup_mmpg_Info> GetMixMaterialGroupMaster()
{
try
{
List<MixMaterialGroup_mmpg_Info> list = new List<MixMaterialGroup_mmpg_Info>();
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("select ");
strSql.AppendLine(" mmpg_Id,mmpg_cMaterialGroupNo,mmpg_cMaterialGroupName,mmpg_cAdd,mmpg_dAddDate,mmpg_cLast,mmpg_dLastDate ");
strSql.AppendLine(" from MixMaterialGroup_mmpg ");
using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (sdr.Read())
{
MixMaterialGroup_mmpg_Info model = new MixMaterialGroup_mmpg_Info();
if (sdr["mmpg_Id"] != null && sdr["mmpg_Id"].ToString() != "")
{
model.mmpg_Id = new Guid(sdr["mmpg_Id"].ToString());
}
if (sdr["mmpg_cMaterialGroupNo"] != null && sdr["mmpg_cMaterialGroupNo"].ToString() != "")
{
model.mmpg_cMaterialGroupNo = sdr["mmpg_cMaterialGroupNo"].ToString();
}
if (sdr["mmpg_cMaterialGroupName"] != null && sdr["mmpg_cMaterialGroupName"].ToString() != "")
{
model.mmpg_cMaterialGroupName = sdr["mmpg_cMaterialGroupName"].ToString();
}
if (sdr["mmpg_cAdd"] != null && sdr["mmpg_cAdd"].ToString() != "")
{
model.mmpg_cAdd = sdr["mmpg_cAdd"].ToString();
}
if (sdr["mmpg_dAddDate"] != null && sdr["mmpg_dAddDate"].ToString() != "")
{
model.mmpg_dAddDate = DateTime.Parse(sdr["mmpg_dAddDate"].ToString());
}
if (sdr["mmpg_cLast"] != null && sdr["mmpg_cLast"].ToString() != "")
{
model.mmpg_cLast = sdr["mmpg_cLast"].ToString();
}
if (sdr["mmpg_dLastDate"] != null && sdr["mmpg_dLastDate"].ToString() != "")
{
model.mmpg_dLastDate = DateTime.Parse(sdr["mmpg_dLastDate"].ToString());
}
list.Add(model);
}
}
return list;
}
catch (Exception ex)
{
throw ex;
}
}
private string GetMixMaterialGroupMasterSQL(MixMaterialGroup_mmpg_Info model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.mmpg_Id != null)
{
strSql1.Append("mmpg_Id,");
strSql2.Append("'" + model.mmpg_Id + "',");
}
if (model.mmpg_cMaterialGroupNo != null)
{
strSql1.Append("mmpg_cMaterialGroupNo,");
strSql2.Append("'" + model.mmpg_cMaterialGroupNo + "',");
}
if (model.mmpg_cMaterialGroupName != null)
{
strSql1.Append("mmpg_cMaterialGroupName,");
strSql2.Append("'" + model.mmpg_cMaterialGroupName + "',");
}
if (model.mmpg_cAdd != null)
{
strSql1.Append("mmpg_cAdd,");
strSql2.Append("'" + model.mmpg_cAdd + "',");
}
if (model.mmpg_dAddDate != null)
{
strSql1.Append("mmpg_dAddDate,");
strSql2.Append("'" + model.mmpg_dAddDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
if (model.mmpg_cLast != null)
{
strSql1.Append("mmpg_cLast,");
strSql2.Append("'" + model.mmpg_cLast + "',");
}
if (model.mmpg_dLastDate != null)
{
strSql1.Append("mmpg_dLastDate,");
strSql2.Append("'" + model.mmpg_dLastDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
strSql.Append("insert into MixMaterialGroup_mmpg(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
return strSql.ToString();
}
public List<MixMaterialGroup_mmpg_Info> SearchRecords(IModelObject searchCondition)
{
List<MixMaterialGroup_mmpg_Info> list = new List<MixMaterialGroup_mmpg_Info>();
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
info = searchCondition as MixMaterialGroup_mmpg_Info;
StringBuilder sqlString = new StringBuilder();
sqlString.AppendLine("SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString());
sqlString.AppendLine("*");
sqlString.AppendLine("FROM MixMaterialGroup_mmpg ");
sqlString.AppendLine("WHERE 1=1 --And mlpf_lIsDeleted=0");
if (info.mmpg_cMaterialGroupNo != "" && info.mmpg_cMaterialGroupNo != null)
{
sqlString.AppendLine("AND mmpg_cMaterialGroupNo='" + info.mmpg_cMaterialGroupNo + "'");
}
if (info.mmpg_cMaterialGroupName != "" && info.mmpg_cMaterialGroupName != null)
{
sqlString.AppendLine("AND mmpg_cMaterialGroupName='" + info.mmpg_cMaterialGroupName + "'");
}
IEnumerable<MixMaterialGroup_mmpg_Info> infos = null;
using (MainDBDataContext db = new MainDBDataContext())
{
infos = db.ExecuteQuery<MixMaterialGroup_mmpg_Info>(sqlString.ToString(), new object[] { });
if (infos != null)
{
list = infos.ToList<MixMaterialGroup_mmpg_Info>();
}
}
return list;
}
public bool UpdateRecord(MixMaterialGroup_mmpg_Info infoObject)
{
bool isSuccess = false;
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialGroup_mmpg query = db.MixMaterialGroup_mmpg.SingleOrDefault(t => t.mmpg_Id == infoObject.mmpg_Id);
if (query != null)
{
query.mmpg_cMaterialGroupNo = infoObject.mmpg_cMaterialGroupNo;
query.mmpg_cMaterialGroupName = infoObject.mmpg_cMaterialGroupName;
query.mmpg_cLast = infoObject.mmpg_cLast;
query.mmpg_dLastDate = infoObject.mmpg_dLastDate;
//query.mlpf_lSync = infoObject.mlpf_lSync;
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}