public static void UpdateP(int categoryId, string p, string code)
{
Category category = CategoryBiz.Instance.GetById(categoryId);
DwNumberBiz biz = new DwNumberBiz(category.DbName);
DwNumber number = biz.GetById(p);
DwNumber newNumber = biz.Create(number.P, number.N, code, number.Date, number.Created.ToString());
newNumber.Seq = number.Seq;
biz.Modify(newNumber, newNumber.P.ToString());
}
public static void Update(int categoryId, string p, string code)
{
Category category = CategoryBiz.Instance.GetById(categoryId);
DwNumberBiz biz = new DwNumberBiz(category.DbName);
DwNumber number = biz.GetById(p);
DwNumber newNumber = biz.Create(number.P, number.N, code, number.Date, number.Created.ToString());
newNumber.Seq = number.Seq;
biz.Modify(newNumber, newNumber.P.ToString());
}
public static void Insert(int categoryId, string speroid, string code, string sdate)
{
string no = code.Replace(" ", ",");
DateTime datetime = DateTime.Parse(sdate);
int dateint = int.Parse(datetime.ToString("yyyyMMdd"));
int p = 2000000000 + int.Parse(speroid);
int n = int.Parse(speroid.Substring(speroid.Length - 2));
Category category = CategoryBiz.Instance.GetById(categoryId);
DwNumberBiz biz = new DwNumberBiz(category.DbName);
//select MAX(seq) seq from DwNumber where P < p;
int seq = biz.DataAccessor.SelectMaxWithCondition(DwNumber.C_Seq, 10, "where P <" + p);
DwNumber number = biz.Create(p, n, no, dateint, sdate);
number.Seq = seq + 1;
//UPDATE DwNumber set Seq=seq+ 1 where P > p;
biz.Add(number);
biz.DataAccessor.UpdateSeq(1, p);
}
public static void Insert(int categoryId, string speroid, string code, string sdate)
{
string no = code.Replace(" ", ",");
DateTime datetime = DateTime.Parse(sdate);
int dateint = int.Parse(datetime.ToString("yyyyMMdd"));
int p = 2000000000 + int.Parse(speroid);
int n = int.Parse(speroid.Substring(speroid.Length - 2));
Category category = CategoryBiz.Instance.GetById(categoryId);
DwNumberBiz biz = new DwNumberBiz(category.DbName);
//select MAX(seq) seq from DwNumber where P < p;
int seq = biz.DataAccessor.SelectMaxWithCondition(DwNumber.C_Seq, 10, "where P <" + p);
DwNumber number = biz.Create(p, n, no, dateint, sdate);
number.Seq = seq + 1;
//UPDATE DwNumber set Seq=seq+ 1 where P > p;
biz.Add(number);
biz.DataAccessor.UpdateSeq(1, p);
}
