/// <summary>
/// 修改款式计算成衣尺寸
/// </summary>
/// <param name="form"></param>
//public static void CountChiCun(ReviseStyle form)
//{
//ImpService.TurnChiCunZero(form);
//foreach (Control card in form.panel4.Controls)
//{
// if (card is ChiCunCard)
// {
// ChiCunCard c = (ChiCunCard)card;
// c.chengyi.Text = (Convert.ToDouble(c.biaozhun.Text) + Convert.ToDouble(c.jia.Text) - Convert.ToDouble(c.jian.Text)).ToString();
// }
//}
//}
/// <summary>
/// 修改款式修改尺寸
/// </summary>
/// <param name="form"></param>
//public static void ReviseChangeChiCun(ReviseStyle form, String sizecd)
//{
// int i2 = SQLmtm.DoUpdate("s_style_p", new string[] { "STYLE_SIZE_CD" }, new string[] { sizecd }, new string[] { "SYS_STYLE_ID" }, new string[] { ReviseStyle.sYS_STYLE_ID });
// if (i2 != 1)
// {
// MessageBox.Show("更改尺寸失败");
// return;
// }
// ImpService.TurnChiCunZero(form);
// Fit_ValueDTo fitv = new Fit_ValueDTo();
// foreach (Control card in form.panel4.Controls)
// {
// if (card is ChiCunCard)
// {
// ChiCunCard c = (ChiCunCard)card;
// fitv.icadd(c.iTEM_CD);
// fitv.ivadd(c.iTEM_VALUE);
// fitv.fvadd(c.chengyi.Text);
// fitv.fmvadd(c.iTEM_VALUE);
// fitv.invadd(c.jia.Text);
// fitv.outvadd(c.jian.Text);
// }
// }
// int i = SQLmtm.DoUpdate("a_customer_fit_value_r", new string[] { "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE" }, new string[] { fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE }, new string[] { "CUSTOMER_COUNT_ID" }, new string[] { CreateCustomer.customer_countid.ToString() });
// if (i != 1)
// {
// MessageBox.Show("更改尺寸失败");
// return;
// }
// int i1 = SQLmtm.DoUpdate("s_style_fit_r", new string[] { "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE" }, new string[] { fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE }, new string[] { "STYLE_ID" }, new string[] { ReviseStyle.sYS_STYLE_ID });
// if (i1 != 1)
// {
// MessageBox.Show("更改尺寸失败");
// return;
// }
//}
/// <summary>
/// 修改款式客户基本信息加载
/// </summary>
/// <param name="form"></param>
//public static void ReviseLoudCustomer(ReviseStyle form)
//{
// DataRow drr = SQLmtm.GetDataRow("SELECT * FROM o_order_p WHERE STYLE_ID='" + ReviseStyle.sYS_STYLE_ID + "'");
// form.beizhu01.Text = drr["REMARKS"].ToString();
// form.dangqiankehu.Text = drr["CUSTOM_NAME"].ToString();
// DataTable dt = SQLmtm.GetDataTable("SELECT * FROM (SELECT * FROM a_customer_fit_r) s1 RIGHT JOIN (SELECT * FROM a_customer_fit_count_r WHERE CUSTOMER_ID ='" + drr["CUSTOMER_ID"].ToString() + "' AND DEFAULT_FLAG ='1') s2 on s1.FIT_COUNT_ID=s2.ID");
// //if(dt.Rows[0]["CUSTOMER_FIT_ID"].ToString()!="")
// //{
// foreach (DataRow dr in dt.Rows)
// {
// if (dr["ITEM_VALUE"].ToString() == "FITMT_ITEM_09")
// {
// form.kehushengao.Text = dr["FIT_VALUE"].ToString();
// }
// if (dr["ITEM_VALUE"].ToString() == "FITMT_ITEM_10")
// {
// form.kehutizhong.Text = dr["FIT_VALUE"].ToString();
// }
// if (dr["ITEM_VALUE"].ToString() == "FITMT_CODE_01")
// {
// switch (dr["FIT_VALUE"].ToString())
// {
// case "1":
// form.kehujianxing.Text = "平肩";
// break;
// case "2":
// form.kehujianxing.Text = "溜肩";
// break;
// case "3":
// form.kehujianxing.Text = "正常";
// break;
// }
// }
// if (dr["ITEM_VALUE"].ToString() == "FITMT_CODE_02")
// {
// switch (dr["FIT_VALUE"].ToString())
// {
// case "4":
// form.kehuduxing.Text = "凹陷";
// break;
// case "5":
// form.kehuduxing.Text = "平坦";
// break;
// case "6":
// form.kehuduxing.Text = "微凸";
// break;
// case "7":
// form.kehuduxing.Text = "中凸";
// break;
// case "8":
// form.kehuduxing.Text = "重凸";
// break;
// }
// }
// }
//}
/// <summary>
/// 修改款式修改备注
/// </summary>
/// <param name="form"></param>
//public static void ReviseSaveBeiZhu(ReviseStyle form)
//{
// int i = SQLmtm.DoUpdate("o_order_p", new string[] { "REMARKS" }, new string[] { form.beizhu01.Text }, new string[] { "ORDER_ID" }, new string[] { ReviseStyle.oRDER_ID });
// if (i != 1)
// {
// MessageBox.Show("修改备注失败");
// return;
// }
//}
/// <summary>
/// 动态加载设计点控件
/// </summary>
/// <param name="change"></param>
public static void LoadSheJiDian(Frm定制下单修改尺寸 change, String styleid)
{
DataTable dt = SQLmtm.GetDataTable("select * from a_kuanshi_p where STYLEID =" + styleid);
if (dt.Rows.Count == 0)
{
MessageBox.Show("请联系管理员完善相关信息");
return;
}
change.panel6.Controls.Clear();
height = 0;
width = 0;
int i = 0;
panelLocition = new PanelLocition(change.panel6.Width, change.panel6.Height, dt.Rows.Count);
foreach (DataRow dr in dt.Rows)
{
if (dr["ITEM_VALUE"].ToString() != "mianliaoid")
{
UC设计点选择 chooseCard = new UC设计点选择(dr["id"].ToString(), dr["ITEM_NAME_CN"].ToString(), dr["ITEM_CD"].ToString(), dr["ITEM_VALUE"].ToString(), dr["DEFAULT_NAME_CN"].ToString(), dr["DEFAULT_CD"].ToString(), dr["DEFAULT_VALUE"].ToString(), "");
ArrayUC(chooseCard, i);
change.panel6.Controls.Add(chooseCard);
i++;
}
else
{
Frm面料选择.mianliaocd = dr["DEFAULT_CD"].ToString();
Frm面料选择.mianliaoid = dr["DEFAULT_VALUE"].ToString();
Frm面料选择.mianliao = change.mianliaoname.Text = dr["DEFAULT_NAME_CN"].ToString();
}
}
}
/// <summary>
/// 动态设计点保存
/// </summary>
/// <param name="change"></param>
public static void DynamicSaveDesign(Frm定制下单修改尺寸 change)
{
UC设计点选择 c = new UC设计点选择();
foreach (Control card in change.panel6.Controls)
{
if (card is UC设计点选择)
{
c = (UC设计点选择)card;
SQLmtm.DoInsert("s_style_option_r", new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" },
new string[] { Frm定制下单修改尺寸.styleid.ToString(), c.PitemCd, c.PitemValue, c.itemValue, "1", "0" });
}
}
}
/// <summary>
/// 动态保存设计点
/// </summary>
/// <param name="frm"></param>
/// <param name="dto"></param>
public static void DynamicSaveDesign(Frm门店下单选款式 frm, Dto定制下单 dto)
{
UC设计点选择 c = new UC设计点选择();
foreach (Control card in frm.panel3.Controls)
{
if (card is UC设计点选择)
{
c = (UC设计点选择)card;
dto.build设计点(c.PitemCd, c.PitemValue, c.itemValue, "1", "0", c.itemName, c.PitemName, c.pic);
// SQLmtm.DoInsert("s_style_option_r", new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" },
//new string[] { Change.styleid.ToString(), c.PitemCd, c.PitemValue, c.itemValue, "1", "0" });
}
}
}
public Frm设计点(UC设计点选择 card, Enum选择设计点类型 enum选择设计点类型)
{
InitializeComponent();
this.enum选择设计点类型 = enum选择设计点类型;
this.card = card;
this.PitemName = this.card.PitemName;
this.PitemValue = this.card.PitemValue;
if (this.enum选择设计点类型 == Enum选择设计点类型.全部)
{
this.Text = "选择全部" + this.card.PitemName;
generatePictureLayout();
}
if (this.enum选择设计点类型 == Enum选择设计点类型.默认)
{
this.Text = "选择默认" + this.card.PitemName;
generatePictureLayout();
}
}
public UC设计点卡片(String itemname, String itemcd, String itemvalue, String picn, Frm设计点 allform, UC设计点选择 card)
{
InitializeComponent();
this.flag = false;
this.itemName = itemname;
this.itemCd = itemcd;
this.itemValue = itemvalue;
this.picN = picn;
this.label1.Text = this.itemValue + ":" + this.itemName;
this.allform = allform;
this.card = card;
try
{
this.pictureBox1.Image = Image.FromFile(@"pic\" + this.picN.Trim());
}
catch
{
}
}
public DefaultSheJiDian(UC设计点选择 card)
{
InitializeComponent();
this.card = card;
}