/// <summary>
///
/// </summary>
/// <param name="yearmonth"></param>
/// <returns></returns>
public List <MODEL.doc_StyleBase> GetOrdertoStyle(string yearmonth)
{
// 从订单自动导入 形体大类的资料
string sql = @"
select Code,CustomName,GoodsTypeName,a.Name,ModelNo,RBcode,MDcode,Editionhandle ,b.OrderDate OrderDate from T_StyleCodeInfo a
right join
(
select distinct MIN(OrderDate) OrderDate,Name,MAX(guid) Guid from T_StyleCodeInfo group by name
) b on b.guid=a.guid
where b.OrderDate>=@OrderDate order By Name
";
SqlParameter p = new SqlParameter("OrderDate", yearmonth);
DataTable dt = SqlHelper.ExcuteTable(sql, p);
List <MODEL.doc_StyleBase> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_StyleBase>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_StyleBase c = new MODEL.doc_StyleBase();
LoadDataToList2(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 比較OrderDate and NewCode 就可以知道是否為新型體 /
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.doc_StyleBase> GetStyleBaseNewCode(string yyyymm, string name)
{
string sql = @"
select distinct Name,NewCode=(select distinct OrderDate+' ' from T_StyleCodeInfo b
where OrderDate>=@OrderDate
and b.Name=a.Name for XML PATH('') )
from T_StyleCodeInfo a
where OrderDate>=@OrderDate and Name=@name
";
SqlParameter[] ps =
{
new SqlParameter("@OrderDate", yyyymm),
new SqlParameter("@Name", name)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.doc_StyleBase> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_StyleBase>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_StyleBase c = new MODEL.doc_StyleBase();
LoadDataToList1(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
///
/// </summary>
/// <param name=" Newcode,Style,StyleBase,Name , ModelNo"></param>
/// <returns></returns>
public List <MODEL.doc_StyleBase> SeeStylebase(string stylebase, string style, string name, string modelno, bool cbdate, string yyyymm)
{
string sql = @"
select * from doc_StyleBase ";
List <string> listWhere = new List <string>();
List <SqlParameter> listParameters = new List <SqlParameter>();
if (stylebase != "")
{
listWhere.Add(" StyleBase like @StyleBase ");
listParameters.Add(new SqlParameter("@StyleBase", "%" + stylebase + "%"));
}
if (style != "")
{
listWhere.Add(" Style like @Style ");
listParameters.Add(new SqlParameter("@Style", "%" + style + "%"));
}
if (name != "")
{
listWhere.Add(" Name like @Name ");
listParameters.Add(new SqlParameter("@Name", "%" + name + "%"));
}
if (modelno != "")
{
listWhere.Add(" ModelNo like @ModelNo ");
listParameters.Add(new SqlParameter("@ModelNo", "%" + modelno + "%"));
}
if (cbdate)
{
listWhere.Add(" NewCode >=@Newcode ");
listParameters.Add(new SqlParameter("@NewCode", "%" + yyyymm + "%"));
}
if (listWhere.Count > 0)
{
string sqlWhere = string.Join(" and ", listWhere.ToArray());
sql = sql + " where " + sqlWhere;
}
DataTable dt = SqlHelper.ExcuteTable(sql, listParameters.ToArray());
List <MODEL.doc_StyleBase> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_StyleBase>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_StyleBase c = new MODEL.doc_StyleBase();
LoadDataToList2(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList2(DataRow dr, MODEL.doc_StyleBase stylebase)
{
stylebase.Guid = (Guid)SqlHelper.FromDbValue(dr["Guid"]); //GUiD
stylebase.CustomName = dr["CustomName"].ToString(); //客户名称
stylebase.CustomNameS = dr["CustomNameS"].ToString(); //客户名称简称..ASICS订单分JR用
stylebase.Style = (string)SqlHelper.FromDbValue(dr["Style"]);
stylebase.StyleBase = (string)SqlHelper.FromDbValue(dr["StyleBase"]);
stylebase.Name = (string)SqlHelper.FromDbValue(dr["Name"]); //客户型体
stylebase.GoodsTypeName = dr["GoodsTypeName"].ToString(); //鞋型种类名称
stylebase.Editionhandle = dr["Editionhandle"].ToString(); //楦头编号
stylebase.Innor = (string)SqlHelper.FromDbValue(dr["Innor"]);
stylebase.RBcode = dr["RBcode"].ToString(); //RB模号
stylebase.MDcode = dr["MDcode"].ToString(); //MD模号
stylebase.ModelNo = dr["ModelNo"].ToString(); //大底编号
stylebase.OrderDate = dr["OrderDate"].ToString(); //大底编号
stylebase.NewCode = (string)SqlHelper.FromDbValue(dr["NewCode"]);
stylebase.HourQty = (string)SqlHelper.FromDbValue(dr["HourQty"]);
}
/// <summary>
/// 获取所有班级信息
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.doc_StyleBase> GetAllStyleBase()
{
string sql = "select * from doc_StyleBase order by CustomName ";
// SqlParameter p = new SqlParameter("", );
DataTable dt = SqlHelper.ExcuteTable(sql);
List <MODEL.doc_StyleBase> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_StyleBase>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_StyleBase c = new MODEL.doc_StyleBase();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList2(DataRow dr, MODEL.doc_StyleBase stylebase)
{
// stylebase. .Code = dr["Code"].ToString(); //工厂型体
// ,ModelNo
stylebase.CustomName = dr["CustomName"].ToString();//客户名称
string[] mystyle = dr["Code"].ToString().Split('/');
stylebase.Style = mystyle[0].ToString().Trim();
stylebase.StyleBase = mystyle[0].ToString().Trim();
// stylebase.Name = (string) SqlHelper.FromDbValue( dr["Name"]);
stylebase.Name = dr["Name"].ToString(); //鞋型种类名称
stylebase.GoodsTypeName = dr["GoodsTypeName"].ToString(); //鞋型种类名称
stylebase.Editionhandle = dr["Editionhandle"].ToString(); //楦头编号
stylebase.Innor = dr["Editionhandle"].ToString(); //鞋垫编号
stylebase.RBcode = dr["RBcode"].ToString(); //RB模号
stylebase.MDcode = dr["MDcode"].ToString(); //MD模号
stylebase.ModelNo = dr["ModelNo"].ToString(); //大底编号
stylebase.OrderDate = dr["OrderDate"].ToString(); //新鞋型日期
stylebase.NewCode = "0";
// stylecode.stylecount = (int)dr["stylecount"];
}
/// 增加人员信息
/// </summary>
/// <param name="addStyleBase"></param>
/// <returns></returns>
public int AddStyleBase(MODEL.doc_StyleBase addStyleBase)
{
//string sql = "";
string sql = @"
insert into doc_StyleBase(Guid, Style, StyleBase,CustomName,GoodsTypeName,Name,ModelNo,RBcode,MDcode,Editionhandle,Innor,OrderDate,NewCode)
values(@Guid, @Style, @StyleBase, @CustomName, @GoodsTypeName, @Name, @ModelNo,@RBcode,@MDcode, @Editionhandle, @Innor, @OrderDate, @NewCode)";
SqlParameter[] ps =
{
new SqlParameter("Guid", addStyleBase.Guid),
new SqlParameter("Style", addStyleBase.Style),
new SqlParameter("StyleBase", addStyleBase.StyleBase),
new SqlParameter("CustomName", addStyleBase.CustomName),
new SqlParameter("GoodsTypeName", addStyleBase.GoodsTypeName),
new SqlParameter("Name", addStyleBase.Name),
new SqlParameter("@ModelNo", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(addStyleBase.ModelNo)
},
new SqlParameter("@RBcode", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(addStyleBase.RBcode)
},
new SqlParameter("@MDcode", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(addStyleBase.MDcode)
},
new SqlParameter("Editionhandle", addStyleBase.Editionhandle),
new SqlParameter("Innor", addStyleBase.Innor),
new SqlParameter("OrderDate", addStyleBase.OrderDate),
new SqlParameter("NewCode", addStyleBase.NewCode)
};
return(SqlHelper.ExecuteNonQuery(sql, ps));
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="name"></param>
/// <param name="newcode"></param>
public void LoadDataToList1(DataRow dr, MODEL.doc_StyleBase stylebase)
{
stylebase.Name = (string)SqlHelper.FromDbValue(dr["Name"]); //客户型体
stylebase.NewCode = (string)SqlHelper.FromDbValue(dr["NewCode"]); //新型體的訂單年月
}
/// 增加人员信息
/// </summary>
/// <param name="addStyleBase"></param>
/// <returns></returns>
public int AddStyleBase(MODEL.doc_StyleBase addStyleBase)
{
return(stb.AddStyleBase(addStyleBase));
}
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() + "筆內盒資料新增");
}
