/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList2(DataRow dr, MODEL.doc_Style style)
{
style.Style = (String)SqlHelper.FromDbValue(dr["Style"]);
style.Code = (String)SqlHelper.FromDbValue(dr["Code"]);
style.Color = (String)SqlHelper.FromDbValue(dr["Color"]);
style.OrderDate = (String)SqlHelper.FromDbValue(dr["OrderDate"]);
style.Image = (Byte[])SqlHelper.FromDbValue(dr["Image"]);
style.NewCode = (String)SqlHelper.FromDbValue(dr["NewCode"]);
}
/// <summary>
///
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.doc_Style> GetAllStyle()
{
string sql = "select * from doc_Style ";
// SqlParameter p = new SqlParameter("", );
DataTable dt = SqlHelper.ExcuteTable(sql);
List <MODEL.doc_Style> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_Style>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_Style d = new MODEL.doc_Style();
LoadDataToList2(row, d);
lists.Add(d);
}
}
return(lists);
}
/// <summary>
/// 增加人员信息
/// </summary>
/// <param name="addStyle"></param>
/// <returns></returns>
public int AddStyle(MODEL.doc_Style addStyle)
{
string sql = "";
sql = " insert into doc_Style(Guid, Code, Style, OrderDate, Color) values(NEWID(), @Code,@Style, @OrderDate, @Color)";
SqlParameter[] ps =
{
// new SqlParameter("Guid",addStyle.Code),
new SqlParameter("Code", addStyle.Code),
new SqlParameter("Style", addStyle.Style),
new SqlParameter("OrderDate", addStyle.OrderDate),
new SqlParameter("@Color", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(addStyle.Color)
}
};
return(SqlHelper.ExecuteNonQuery(sql, ps));
}
private void btnALLStyle_Click(object sender, EventArgs e)
{
#region ----------------StyleBase
int aa = 0;
///*
// 从订单中提出形体大类需要的资讯 ,使用唯一的Code 工厂型体捉出订单中大类的其他栏位
sblist = od.GetOrdertolStyle(YearMounth.Text);
MODEL.doc_StyleBase sb = new MODEL.doc_StyleBase();
for (int k = 0; k < sblist.Count; k++)
{
test.Clear();
sb.Guid = System.Guid.NewGuid();
sb.Style = sblist[k].Style;
sb.StyleBase = sblist[k].StyleBase;
sb.Name = sblist[k].Name;
sb.CustomName = sblist[k].CustomName;
// sb.CustomNameS = sblist[k].CustomNameS;
sb.GoodsTypeName = sblist[k].GoodsTypeName;
sb.ModelNo = sblist[k].ModelNo;
sb.RBcode = sblist[k].RBcode;
sb.MDcode = sblist[k].MDcode;
sb.Editionhandle = sblist[k].Editionhandle;
sb.Innor = sblist[k].Editionhandle;
sb.OrderDate = sblist[k].OrderDate;
sb.NewCode = sblist[k].NewCode;
test.AppendText("型体大类" + "\r\n" + sb.Style + sb.OrderDate + "\r\n" + (k + 1).ToString() + "/" + sblist.Count.ToString());
if (sbm.IsStyleBaseExisits(sblist[k].Name) < 1)
{
// MessageBox.Show("自动增加" + sb.Name);
sbm.AddStyleBase(sb);
aa = aa + 1;
}
;
}
//*/
MessageBox.Show(aa.ToString() + "筆新型體新增");
#endregion
#region ----- add StyleBase newcode
///*
BLL.doc_StyleBaseManager sbm1 = new BLL.doc_StyleBaseManager();
sblist1 = sbm.GetAllStyleBase();
for (int l = 0; l < sblist1.Count; l++)
{
test.Clear();
// MessageBox.Show(sblist1[l].Name);
string mycode = "";
mycode = sbm.GetSBNewCode(YearMounth.Text, sblist1[l].Name);
test.AppendText("型体日期" + "\r\n" + mycode + "\r\n" + (l + 1).ToString() + "/" + sblist1.Count.ToString());
sbm1.updateStylebaseNewCode(sblist1[l].Name, mycode);
}
sblist1 = sbm.GetAllStyleBase();
this.dgvStyleBase.DataSource = sblist1;
///*/
#endregion -----end add new code
#region ----------------Style
// /*
int myadd = 0;
odlist = od.GetAllCode(YearMounth.Text);
List <MODEL.doc_Style> lists = null;
lists = new List <MODEL.doc_Style>();
for (int b = 0; b < odlist.Count; b++)
{
test.Clear();
MODEL.doc_Style c = new MODEL.doc_Style();
c.Code = odlist[b].Code;
string[] mycode = odlist[b].Code.Split('/');
c.Style = mycode[0].Trim();
c.Guid = new Guid();
//判断如果没有/ 那么长度就会为1(一段)
// if (odlist[j].Code.Length > mycode[0].Length)
if (mycode.Length > 1)
{
c.Color = mycode[1].Trim();
}
;
c.OrderDate = odlist[b].OrderDate;
test.AppendText("型体配色" + "\r\n" + "c.Style" + "\r\n" + (b + 1).ToString() + "/" + odlist.Count.ToString());
lists.Add(c);
if (sm.IsCodeExisits(odlist[b].Code) < 1)
{
sm.AddStyle(c);
myadd++;
}
}
MessageBox.Show(myadd.ToString() + "筆新配色新增");
//*/
#endregion
#region ----- add style newcode
///*
BLL.doc_StyleManager sm1 = new BLL.doc_StyleManager();
slist1 = sm1.GetAllStyle();
for (int c = 0; c < slist1.Count; c++)
{
test.Clear();
// MessageBox.Show(sblist1[l].Name);
string mycode1 = "";
mycode1 = sm.GetSNewCode(YearMounth.Text, slist1[c].Code);
test.AppendText("型体配色日期" + "\r\n" + mycode1 + "\r\n" + (c + 1).ToString() + "/" + slist1.Count.ToString());
sm1.updateStyleNewCode(slist1[c].Code, mycode1);
}
//*/
#endregion -----end add new code
#region -------stylesize
int sscount = 0;
//*
sslist = null;
sslist = ssm.GetStyleSizefromOrder(YearMounth.Text);
List <MODEL.doc_StyleSize> sslists = null;
sslists = new List <MODEL.doc_StyleSize>();
for (int a = 0; a < sslist.Count; a++)
{
test.Clear();
MODEL.doc_StyleSize ss = new MODEL.doc_StyleSize();
ss.Guid = System.Guid.NewGuid();
ss.Style = sslist[a].Style;
ss.StyleBase = sslist[a].StyleBase;
// 取消sStyleBase
ss.OrderDate = sslist[a].OrderDate;
// 取消OrderDate 由於Code 不規範 (有些中間會有空格) ,所以OrderDate會多筆
ss.Size = sslist[a].Size;
ss.NewCode = "";
ss.BoxSize = "";
ss.Section = "";
ss.Unit = "cm";
ss.Weight = 0;
ss.Range = null;
ss.L = null;
ss.W = null;
ss.H = null;
test.AppendText("型体尺码" + "\r\n" + ss.Style + "\r\n" + (a + 1).ToString() + "/" + sslist.Count.ToString());
sslists.Add(ss);
if (ssm.IsStyleSizeExisits(ss.Style, ss.Size) < 1)
{
ssm.AddStyleSize(ss);
sscount++;
}
;
sslists.Clear();
}
// */
MessageBox.Show(sscount.ToString() + "筆型體尺碼新增");
#endregion
#region ----- add stylesize new code
///*
BLL.doc_StyleSIzeManager ssm1 = new BLL.doc_StyleSIzeManager();
sslist1 = ssm1.GetAllStyleSize();
for (int c = 0; c < sslist1.Count; c++)
{
test.Clear();
// MessageBox.Show(sblist1[l].Name);
string mycode2 = "";
mycode2 = ssm1.GetSBNewCodeToSS(YearMounth.Text, sslist1[c].Style);
test.AppendText("型体尺码日期" + "\r\n" + mycode2 + "\r\n" + (c + 1).ToString() + "/" + sslist1.Count.ToString());
ssm1.updateStyleSizeNewCode(sslist1[c].Style, mycode2);
}
//*/
MessageBox.Show("更新完毕");
#endregion -----end add stylesize new code
}
// BLL.doc_StyleBaseManager stm = new BLL.doc_StyleBaseManager();
private void btnALLStyle_Click(object sender, EventArgs e)
{
//----------------StyleBase
// 从订单中提出形体大类需要的资讯 ,使用唯一的Code 工厂型体捉出订单中大类的其他栏位
stylist = od.GetOrdertolStyle(YearMounth.Text);
MODEL.doc_StyleBase sb = new MODEL.doc_StyleBase();
int aa = 0;
for (int k = 0; k < stylist.Count; k++)
{
test.Clear();
sb.Guid = System.Guid.NewGuid();
sb.Style = stylist[k].Style;
sb.StyleBase = stylist[k].StyleBase;
sb.Name = stylist[k].Name;
sb.CustomName = stylist[k].CustomName;
sb.GoodsTypeName = stylist[k].GoodsTypeName;
sb.ModelNo = stylist[k].ModelNo;
sb.RBcode = stylist[k].RBcode;
sb.MDcode = stylist[k].MDcode;
sb.Editionhandle = stylist[k].Editionhandle;
sb.Innor = stylist[k].Editionhandle;
sb.OrderDate = stylist[k].OrderDate;
sb.NewCode = stylist[k].NewCode;
test.AppendText("型体大类" + "\r\n" + sb.Style + sb.OrderDate + "\r\n" + (k + 1).ToString() + "/" + stylist.Count.ToString());
if (sbm.IsStyleBaseExisits(stylist[k].Name) < 1)
{
// MessageBox.Show("自动增加" + sb.Name);
sbm.AddStyleBase(sb);
aa = aa + 1;
}
;
}
MessageBox.Show(aa.ToString() + "筆新型體新增");
// List<MODEL.doc_StyleBase> stybase = null;
// stybase = stm.GetAllStyleBase();
// this.dgvStyleBase.DataSource = stybase;
//----------------Style
int myadd = 0;
odlist = od.GetAllCode(YearMounth.Text);
List <MODEL.doc_Style> lists = null;
lists = new List <MODEL.doc_Style>();
for (int j = 0; j < odlist.Count; j++)
{
test.Clear();
MODEL.doc_Style c = new MODEL.doc_Style();
c.Code = odlist[j].Code;
string[] mycode = odlist[j].Code.Split('/');
c.Style = mycode[0].Trim();
c.Guid = new Guid();
//判断如果没有/ 那么长度就会为1(一段)
// if (odlist[j].Code.Length > mycode[0].Length)
if (mycode.Length > 1)
{
c.Color = mycode[1].Trim();
}
;
c.OrderDate = odlist[j].OrderDate;
test.AppendText("型体" + "\r\n" + c.Style + c.OrderDate + "\r\n" + (j + 1).ToString() + "/" + odlist.Count.ToString());
lists.Add(c);
if (sm.IsCodeExisits(odlist[j].Code) < 1)
{
sm.AddStyle(c);
myadd++;
}
}
MessageBox.Show(myadd.ToString() + "筆新配色新增");
//-------stylesize
sslist = null;
sslist = ssm.GetStyleSizefromOrder(YearMounth.Text);
List <MODEL.doc_StyleSize> sslists = null;
sslists = new List <MODEL.doc_StyleSize>();
int sscount = 0;
for (int j = 0; j < sslist.Count; j++)
{
test.Clear();
MODEL.doc_StyleSize ss = new MODEL.doc_StyleSize();
ss.Guid = System.Guid.NewGuid();
ss.Style = sslist[j].Style;
ss.StyleBase = sslist[j].StyleBase;
// 取消sStyleBase
ss.OrderDate = sslist[j].OrderDate;
// 取消OrderDate 由於Code 不規範 (有些中間會有空格) ,所以OrderDate會多筆
ss.Size = sslist[j].Size;
ss.NewCode = "";
ss.BoxSize = "";
ss.Section = "";
ss.Unit = "cm";
ss.Weight = null;
ss.Range = null;
ss.L = null;
ss.W = null;
ss.H = null;
test.AppendText("型体尺码" + "\r\n" + ss.Style + ss.Size + "\r\n" + (j + 1).ToString() + "/" + sslist.Count.ToString());
sslists.Add(ss);
if (ssm.IsStyleSizeExisits(ss.Style, ss.Size) < 1)
{
ssm.AddStyleSize(ss);
sscount++;
}
;
sslists.Clear();
}
MessageBox.Show(sscount.ToString() + "筆型體尺碼新增");
//------- inneer Box
//獲得該月訂單年月的型體尺碼數量
solist = null;
solist = ibm.GetInnerfromOrder(YearMounth.Text);
// MessageBox.Show(solist.Count.ToString());
string show = solist.Count.ToString();
int ibcount = 0;
List <MODEL.doc_InnerBox> iblists = null;
iblists = new List <MODEL.doc_InnerBox>();
// doc_innorbox 沒有尺碼的增加 ,使用 name , size, color 判斷
for (int j = 0; j < solist.Count; j++)
{
test.Clear();
MODEL.doc_InnerBox ib = new MODEL.doc_InnerBox();
ib.Guid = System.Guid.NewGuid();
ib.InnerBarcode = "";
ib.Name = solist[j].Name.Trim();
ib.Style = solist[j].Style.Trim();
ib.Color = solist[j].Color.Trim();
ib.Size = solist[j].Size.Trim();
test.AppendText("内盒资料" + "\r\n" + ib.Name + ib.Color + ib.Size + "\r\n" + (j + 1).ToString() + "/" + solist.Count.ToString());
ib.CustomName = solist[j].CustomName;
ib.Type = "";
ib.StyleCode = solist[j].Name + "." + solist[j].Color;
ib.NewCode = "";
iblists.Add(ib);
if (ibm.IsInnerBoxExisits(ib.Name, ib.Color, ib.Size) < 1)
{
ibm.AddInnerBox(ib);
ibcount++;
}
}
MessageBox.Show(ibcount.ToString() + "筆內盒資料新增");
}
/// <summary>
/// 增加人员信息
/// </summary>
/// <param name="addStyle"></param>
/// <returns></returns>
public int AddStyle(MODEL.doc_Style addStyle)
{
return(st.AddStyle(addStyle));
}
