public string GeneralMailerCode(string postId)
{
var post = db.BS_PostOffices.Where(p => p.PostOfficeID == postId).FirstOrDefault();
if (post == null)
{
return("");
}
var charFirst = post.AreaChar + DateTime.Now.ToString("ddMMyy");
var codeSearch = "mailer" + post.AreaChar;
var find = db.GeneralCodeInfoes.Where(p => p.Code == codeSearch && p.FirstChar == charFirst).FirstOrDefault();
if (find == null)
{
var generalCode = new GeneralCodeInfo()
{
Id = Guid.NewGuid().ToString(),
PreNumber = 0,
FirstChar = charFirst,
Code = codeSearch
};
db.GeneralCodeInfoes.Add(generalCode);
db.SaveChanges();
return(GeneralMailerCode(postId));
}
var number = find.PreNumber + 1;
string code = number.ToString();
int count = 5;
if (code.Count() < 5)
{
count = count - code.Count();
while (count > 0)
{
code = "0" + code;
count--;
}
}
find.PreNumber = find.PreNumber + 1;
db.Entry(find).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(find.FirstChar + code);
}
public string GeneralCusGroupCode()
{
var find = db.GeneralCodeInfoes.Where(p => p.Code == "GCUSTOMER").FirstOrDefault();
if (find == null)
{
var data = new GeneralCodeInfo()
{
Id = Guid.NewGuid().ToString(),
Code = "GCUSTOMER",
FirstChar = "",
PreNumber = 0
};
db.GeneralCodeInfoes.Add(data);
db.SaveChanges();
return(GeneralCusGroupCode());
}
var number = find.PreNumber + 1;
string code = number.ToString();
int count = 4;
if (code.Count() < 4)
{
count = count - code.Count();
while (count > 0)
{
code = "0" + code;
count--;
}
}
find.PreNumber = find.PreNumber + 1;
db.Entry(find).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(code);
}
public string GeneralCusCode(string groupId)
{
string codeSearch = "CUSTOMER" + groupId;
var find = db.GeneralCodeInfoes.Where(p => p.Code == codeSearch).FirstOrDefault();
if (find == null)
{
var data = new GeneralCodeInfo()
{
Id = Guid.NewGuid().ToString(),
Code = codeSearch,
FirstChar = groupId,
PreNumber = 0
};
db.GeneralCodeInfoes.Add(data);
db.SaveChanges();
return(GeneralCusCode(groupId));
}
var number = find.PreNumber + 1;
string code = number.ToString();
int count = 2;
if (code.Count() < 2)
{
count = count - code.Count();
while (count > 0)
{
code = "0" + code;
count--;
}
}
find.PreNumber = find.PreNumber + 1;
db.Entry(find).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(groupId + code);
}
