public bool DeleteRecord(IModelObject KeyObject) { bool isSuccess = false; MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); info = KeyObject as MixMaterialDetail_mmdl_Info; using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl delTab = null; if (info.mmdl_Id != new Guid()) { delTab = db.MixMaterialDetail_mmdl.SingleOrDefault(t => t.mmdl_Id == info.mmdl_Id); if (delTab != null) { db.MixMaterialDetail_mmdl.DeleteOnSubmit(delTab); } } else { var del = db.MixMaterialDetail_mmdl.Where(t => (info.mmdl_cMaterialCode != null ? t.mmdl_cMaterialCode == info.mmdl_cMaterialCode : true) && (info.mmdl_cMaterialGroupNo != null ? t.mmdl_cMaterialGroupNo == info.mmdl_cMaterialGroupNo : true) ); db.MixMaterialDetail_mmdl.DeleteAllOnSubmit(del); } //if (info.mmdl_cMaterialGroupNo != null) //{ // var del = db.MixMaterialDetail_mmdl.Where(c => c.mmdl_cMaterialGroupNo == info.mmdl_cMaterialGroupNo); // db.MixMaterialDetail_mmdl.DeleteAllOnSubmit(del); //} db.SubmitChanges(); isSuccess = true; } return isSuccess; }
public MixMaterialDetail_mmdl_Info DisplayRecord(IModelObject KeyObject) { MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl disTab = db.MixMaterialDetail_mmdl.SingleOrDefault(t => t.mmdl_Id == ((KeyObject) as MixMaterialDetail_mmdl_Info).mmdl_Id); if (disTab != null) { info = Common.General.CopyObjectValue<MixMaterialDetail_mmdl, MixMaterialDetail_mmdl_Info>(disTab); } } return info; }
public bool InsertRecord(MixMaterialDetail_mmdl_Info infoObject) { bool isSuccess = false; MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); info = infoObject; using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl newTab = Common.General.CopyObjectValue<MixMaterialDetail_mmdl_Info, MixMaterialDetail_mmdl>(infoObject); db.MixMaterialDetail_mmdl.InsertOnSubmit(newTab); db.SubmitChanges(); isSuccess = true; } return isSuccess; }
public ReturnValueInfo Save_SQL(IModelObject itemEntity, DefineConstantValue.EditStateEnum EditMode) { ReturnValueInfo returnValue = new ReturnValueInfo(); MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); returnValue.messageText = ""; info = itemEntity as MixMaterialDetail_mmdl_Info; try { switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Insert: bool isExist = false; isExist = _MixMaterialDetailSQL.IsExistRecord(info); if (!isExist) { returnValue.boolValue = _MixMaterialDetailSQL.InsertRecord(info); } else { returnValue.boolValue = false; returnValue.messageText = "數據重複!"; } break; case Common.DefineConstantValue.EditStateEnum.OE_Update: returnValue.boolValue = _MixMaterialDetailSQL.UpdateRecord(info); break; case Common.DefineConstantValue.EditStateEnum.OE_Delete: returnValue.boolValue = _MixMaterialDetailSQL.DeleteRecord(info); break; } } catch (Exception Ex) { throw Ex; } return returnValue; }
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); } } }
public bool UpdateRecord(MixMaterialDetail_mmdl_Info infoObject) { bool isSuccess = false; using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl query = db.MixMaterialDetail_mmdl.SingleOrDefault(t => t.mmdl_Id == infoObject.mmdl_Id); if (query != null) { query.mmdl_cMaterialCode = infoObject.mmdl_cMaterialCode; query.mmdl_cMaterialGroupNo = infoObject.mmdl_cMaterialGroupNo; query.mmdl_fMaterialProportion = infoObject.mmdl_fMaterialProportion; //query.mlpf_lSync = infoObject.mlpf_lSync; db.SubmitChanges(); isSuccess = true; } } return isSuccess; }
public List<MixMaterialDetail_mmdl_Info> SearchRecords(IModelObject searchCondition) { List<MixMaterialDetail_mmdl_Info> list = new List<MixMaterialDetail_mmdl_Info>(); MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); info = searchCondition as MixMaterialDetail_mmdl_Info; StringBuilder sqlString = new StringBuilder(); sqlString.AppendLine("SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString()); sqlString.AppendLine("*"); sqlString.AppendLine("FROM MixMaterialDetail_mmdl "); sqlString.AppendLine("WHERE 1=1 --And mlpf_lIsDeleted=0"); if (info.mmdl_cMaterialCode != "" && info.mmdl_cMaterialCode != null) { sqlString.AppendLine("AND mmdl_cMaterialCode='" + info.mmdl_cMaterialCode + "'"); } if (info.mmdl_cMaterialGroupNo != "" && info.mmdl_cMaterialGroupNo != null) { sqlString.AppendLine("AND mmdl_cMaterialGroupNo='" + info.mmdl_cMaterialGroupNo + "'"); } IEnumerable<MixMaterialDetail_mmdl_Info> infos = null; using (MainDBDataContext db = new MainDBDataContext()) { infos = db.ExecuteQuery<MixMaterialDetail_mmdl_Info>(sqlString.ToString(), new object[] { }); if (infos != null) { list = infos.ToList<MixMaterialDetail_mmdl_Info>(); } } return list; }
/// <summary> /// 物料群組明細主檔 /// </summary> public List<MixMaterialDetail_mmdl_Info> GetMixMaterialDetailMaster() { try { List<MixMaterialDetail_mmdl_Info> list = new List<MixMaterialDetail_mmdl_Info>(); StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select "); strSql.AppendLine("mmdl_Id,mmdl_cMaterialCode,mmdl_cMaterialGroupNo,mmdl_fMaterialProportion "); strSql.AppendLine("from MixMaterialDetail_mmdl "); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { MixMaterialDetail_mmdl_Info model = new MixMaterialDetail_mmdl_Info(); if (sdr["mmdl_Id"] != null && sdr["mmdl_Id"].ToString() != "") { model.mmdl_Id = new Guid(sdr["mmdl_Id"].ToString()); } if (sdr["mmdl_cMaterialCode"] != null && sdr["mmdl_cMaterialCode"].ToString() != "") { model.mmdl_cMaterialCode = sdr["mmdl_cMaterialCode"].ToString(); } if (sdr["mmdl_cMaterialGroupNo"] != null && sdr["mmdl_cMaterialGroupNo"].ToString() != "") { model.mmdl_cMaterialGroupNo = sdr["mmdl_cMaterialGroupNo"].ToString(); } if (sdr["mmdl_fMaterialProportion"] != null && sdr["mmdl_fMaterialProportion"].ToString() != "") { model.mmdl_fMaterialProportion = decimal.Parse(sdr["mmdl_fMaterialProportion"].ToString()); } list.Add(model); } } return list; } catch (Exception ex) { throw ex; } }
private string GetMixMaterialDetailMasterSQL(MixMaterialDetail_mmdl_Info model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.mmdl_Id != null) { strSql1.Append("mmdl_Id,"); strSql2.Append("'" + model.mmdl_Id + "',"); } if (model.mmdl_cMaterialCode != null) { strSql1.Append("mmdl_cMaterialCode,"); strSql2.Append("'" + model.mmdl_cMaterialCode + "',"); } if (model.mmdl_cMaterialGroupNo != null) { strSql1.Append("mmdl_cMaterialGroupNo,"); strSql2.Append("'" + model.mmdl_cMaterialGroupNo + "',"); } if (model.mmdl_fMaterialProportion != null) { strSql1.Append("mmdl_fMaterialProportion,"); strSql2.Append("" + model.mmdl_fMaterialProportion + ","); } strSql.Append("insert into MixMaterialDetail_mmdl("); 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(); }