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();
}
}
