public static EF6.SystemLabel GetByLanguageCode(string code) { EF6.SystemLabel result = null; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.SystemLabel.Where(x => x.LanguageCode == code).AsNoTracking().FirstOrDefault(); if (item != null) { result = item; } } return(result); }
private void SaveLabel_Cht() { bool isNew = false; using (var ctx = new EF6.RT2020Entities()) { var oLabel = ctx.SystemLabel.Where(x => x.LanguageCode == "zh-CHT").FirstOrDefault(); if (oLabel == null) { oLabel = new EF6.SystemLabel(); oLabel.LabelId = Guid.NewGuid(); oLabel.LanguageCode = "zh-CHT"; ctx.SystemLabel.Add(oLabel); isNew = true; } oLabel.STKCODE = this.txtStockCode_Cht.Text.Trim(); oLabel.APPENDIX1 = this.txtAppendix1_Cht.Text.Trim(); oLabel.APPENDIX2 = this.txtAppendix2_Cht.Text.Trim(); oLabel.APPENDIX3 = this.txtAppendix3_Cht.Text.Trim(); oLabel.CLASS1 = this.txtClass1_Cht.Text.Trim(); oLabel.CLASS2 = this.txtClass2_Cht.Text.Trim(); oLabel.CLASS3 = this.txtClass3_Cht.Text.Trim(); oLabel.CLASS4 = this.txtClass4_Cht.Text.Trim(); oLabel.CLASS5 = this.txtClass5_Cht.Text.Trim(); oLabel.CLASS6 = this.txtClass6_Cht.Text.Trim(); oLabel.SERIALNO = this.txtSerialNumber_Cht.Text.Trim(); oLabel.VITEMNO = this.txtVITEMNO_Cht.Text.Trim(); oLabel.COUPONNO = this.txtCouponNumber_Cht.Text.Trim(); oLabel.REMARK1 = this.txtRemarks1_Cht.Text.Trim(); oLabel.REMARK2 = this.txtRemarks2_Cht.Text.Trim(); oLabel.REMARK3 = this.txtRemarks3_Cht.Text.Trim(); oLabel.REMARK4 = this.txtRemarks4_Cht.Text.Trim(); oLabel.REMARK5 = this.txtRemarks5_Cht.Text.Trim(); oLabel.REMARK6 = this.txtRemarks6_Cht.Text.Trim(); if (isNew) { oLabel.DLFLAG = "A"; } else { oLabel.DLFLAG = "M"; } ctx.SaveChanges(); } }