/// <summary>
/// 修改尺寸将空尺寸设为0
/// </summary>
/// <param name="form"></param>
//public static void TurnChiCunZero(ReviseStyle form)
//{
//foreach (Control card in form.panel4.Controls)
//{
// if (card is ChiCunCard)
// {
// ChiCunCard c = (ChiCunCard)card;
// if (c.biaozhun.Text == "")
// {
// c.biaozhun.Text = "0";
// }
// if (c.jia.Text == "")
// {
// c.jia.Text = "0";
// }
// if (c.jian.Text == "")
// {
// c.jian.Text = "0";
// }
// }
//}
//}
/// <summary>
/// 计算成衣尺寸
/// </summary>
/// <param name="change"></param>
public static void CountChiCun(Frm定制下单修改尺寸 change)
{
ImpService.TurnChiCunZero(change);
foreach (Control card in change.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
c.chengyi.Text = (Convert.ToDouble(c.biaozhun.Text) + Convert.ToDouble(c.jia.Text) - Convert.ToDouble(c.jian.Text)).ToString();
}
}
}
// public static void ReviseDynamicSaveSize(ReviseStyle form, int sTYLE_FIT_ID, String customername)
// {
// 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);
// }
// }
// SQLmtm.DoInsert("a_customer_fit_value_r", new string[] { "STYLE_FIT_ID", "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }, new string[] { sTYLE_FIT_ID.ToString(), CreateCustomer.cUSTOMER_ID.ToString(), customername, fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE, "0", "0", CreateCustomer.customer_countid.ToString() });
// SQLmtm.DoInsert("s_style_fit_r", new string[] { "STYLE_ID", "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" },
//new string[] { Change.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, "0", "1", "46", fitv.iN_VALUE, fitv.oUT_VALUE });
// }
/// <summary>
/// 刷新尺寸
/// </summary>
/// <param name="change"></param>
/// <param name="dt"></param>
public static void RefreshChiCun(Frm定制下单修改尺寸 change, DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
foreach (Control card in change.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
if (dr["ITEM_VALUE"].ToString() == c.iTEM_VALUE)
{
c.biaozhun.Text = dr["ITEM_FIT_VALUE"].ToString();
break;
}
}
}
}
}
/// <summary>
/// 修改款式刷新尺寸
/// </summary>
/// <param name="form"></param>
/// <param name="dt"></param>
//public static void RefreshChiCun(ReviseStyle form, DataTable dt)
//{
//foreach (DataRow dr in dt.Rows)
//{
// foreach (Control card in form.panel4.Controls)
// {
// if (card is ChiCunCard)
// {
// ChiCunCard c = (ChiCunCard)card;
// if (dr["ITEM_VALUE"].ToString() == c.iTEM_VALUE)
// {
// c.biaozhun.Text = dr["ITEM_FIT_VALUE"].ToString();
// break;
// }
// }
// }
//}
//}
/// <summary>
/// 将空尺寸设为0
/// </summary>
/// <param name="change"></param>
public static void TurnChiCunZero(Frm定制下单修改尺寸 change)
{
foreach (Control card in change.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
if (c.biaozhun.Text == "")
{
c.biaozhun.Text = "0";
}
if (c.jia.Text == "")
{
c.jia.Text = "0";
}
if (c.jian.Text == "")
{
c.jian.Text = "0";
}
}
}
}
/// <summary>
/// 动态保存尺寸
/// </summary>
/// <param name="change"></param>
public static void DynamicSaveSize(Frm定制下单修改尺寸 change, int sTYLE_FIT_ID, String customername)
{
ImpService.TurnChiCunZero(change);
Fit_ValueDTo fitv = new Fit_ValueDTo();
foreach (Control card in change.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)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);
}
}
SQLmtm.DoInsert("a_customer_fit_value_r", new string[] { "STYLE_FIT_ID", "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }, new string[] { sTYLE_FIT_ID.ToString(), Frm客户.cUSTOMER_ID.ToString(), customername, fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE, "0", "0", Frm客户.customer_countid.ToString() });
SQLmtm.DoInsert("s_style_fit_r", new string[] { "STYLE_ID", "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" },
new string[] { Frm定制下单修改尺寸.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, "0", "1", "46", fitv.iN_VALUE, fitv.oUT_VALUE });
}
/// <summary>
/// 尺寸空设为0
/// </summary>
/// <param name="frm"></param>
public static void TurnChiCunZero(Frm门店下单选款式 frm)
{
foreach (Control card in frm.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
if (c.biaozhun.Text == "")
{
c.biaozhun.Text = "0";
}
if (c.jia.Text == "")
{
c.jia.Text = "0";
}
if (c.jian.Text == "")
{
c.jian.Text = "0";
}
}
}
}
/// <summary>
/// 动态设计点保存
/// </summary>
/// <param name="frm"></param>
/// <param name="dto"></param>
public static void DynamicSaveSize(Frm门店下单选款式 frm, Dto定制下单 dto)
{
ImpService.TurnChiCunZero(frm);
Fit_ValueDTo fitv = new Fit_ValueDTo();
foreach (Control card in frm.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
fitv.icadd(c.iTEM_CD); //ITEM_CD 衣服CD
fitv.ivadd(c.iTEM_VALUE); //ITEM_VALUE 衣服VALUE
fitv.fvadd(c.chengyi.Text); // garmentSize 成衣尺寸
fitv.fmvadd(c.iTEM_VALUE); //ITEM_VALUE 衣服VALUE
fitv.invadd(c.jia.Text); //IN_VALUE 加值
fitv.outvadd(c.jian.Text); //OUT_VALUE 减值
}
}
dto.build尺寸(
fitv.iTEM_CD
, fitv.iTEM_VALUE
, fitv.fitValue
, fitv.fM_VALUE
, fitv.iN_VALUE
, fitv.oUT_VALUE
, "0"
, "0"
, Frm客户.customer_countid.ToString()
, "AUDIT_PHASE_CD-PHASE_CD_10"
, "1"
, "46"
);
// SQLmtm.DoInsert("a_customer_fit_value_r", new string[] { "STYLE_FIT_ID", "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }, new string[] { sTYLE_FIT_ID.ToString(), CreateCustomer.cUSTOMER_ID.ToString(), customername, fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE, "0", "0", CreateCustomer.customer_countid.ToString() });
// SQLmtm.DoInsert("s_style_fit_r", new string[] { "STYLE_ID", "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" },
//new string[] { Change.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, "0", "1", "46", fitv.iN_VALUE, fitv.oUT_VALUE });
}
/// <summary>
/// 动态加载尺寸控件
/// </summary>
/// <param name="change"></param>
/// <param name="sc"></param>
public static void LoadChiCunCard(Frm定制下单修改尺寸 change, UC款式卡片 sc)
{
DataTable dt = SQLmtm.GetDataTable("SELECT\n" +
" sp.FIT_ITEM_VALUE,\n" +
" property.PROPERTY_CD propertyCd,\n" +
"/*量体属性CD*/\n" +
"property.PROPERTY_VALUE propertyValue,\n" +
"/*量体VALUE*/\n" +
" sp.ITEM_IN_FROM propertyInFrom,\n" +
"/*量体属性值可增加范围从*/\n" +
" sp.ITEM_IN_TO propertyInTo,\n" +
"/*量体属性值可增加范围到*/\n" +
" sp.ITEM_OUT_FROM propertyOutFrom,\n" +
"/*量体属性值可缩减范围从*/\n" +
" sp.ITEM_OUT_TO propertyOutTo,\n" +
"/*量体属性值可缩减范围到*/\n" +
" property.PROPERTY_NAME_CN propertyNameCn,\n" +
"/*量体属性中文名称*/\n" +
" property.FIT_USE_TYPE_CD fitUseTypeCd,\n" +
"/*0-非净量体，1-净量体*/\n" +
" property.PROPERTY_UNIT_CD propertyUnitCd ,\n" +
" sp.ITEM_SORT,\n" +
" sp.ITEM_CD,\n" +
" sp.ITEM_VALUE\n" +
"FROM\n" +
" a_fit_property_p property\n" +
" LEFT JOIN a_size_fit_p sp ON property.PROPERTY_CD = sp.ITEM_CD \n" +
" AND property.PROPERTY_VALUE = sp.ITEM_VALUE \n" +
"WHERE\n" +
" property.PROPERTY_CD IN ( SELECT PROPERTY_VALUE FROM a_fit_property_p WHERE style_category_cd = '" + sc.sTYLE_CATEGORY_CD + "' ) \n" +
" AND property.DEL_FLG = 0 \n" +
" AND sp.FIT_CD = '" + sc.sTYLE_FIT_CD + "' /*款式*/\n" +
" AND sp.SIZEGROUP_CD = '" + sc.sTYLE_SIZE_GROUP_CD + "' \n" +
"-- AND sp.SIZE_CD = '" + sc.sTYLE_SIZE_CD + "' /*尺码*/\n" +
" AND property.FIT_USE_TYPE_CD = \"FIT_USE_TYPE-FIT_TYPE_20\" \n" +
" AND sp.ENABLE_FLAG = 1 \n" +
" AND property.FIT_FLAG = 1 \n" +
" AND sp.ITEM_VALUE != \"CIRCU_ITEM_09\" \n" +
"GROUP BY property.PROPERTY_VALUE \n" +
"ORDER BY\n" +
" -- property.PROPERTY_CD,sp.ITEM_SORT ASC\n" +
" sp.ITEM_SORT ASC");
//change.panel3.Controls.Clear();
height = 0;
width = 0;
int i = 0;
panelLocition = new PanelLocition(change.panel4.Width, change.panel4.Height, dt.Rows.Count);
UC尺寸头 hhh = new UC尺寸头();
ImpService.generateUserControl(hhh, i);
change.panel4.Controls.Add(hhh);
i++;
foreach (DataRow dr in dt.Rows)
{
UC尺寸卡片 ccc = new UC尺寸卡片(dr["ITEM_CD"].ToString().Trim(), dr["ITEM_VALUE"].ToString(), dr["propertyNameCn"].ToString(), dr["FIT_ITEM_VALUE"].ToString(), change);
ImpService.generateUserControl(ccc, i);
change.panel4.Controls.Add(ccc);//将控件加入panel
i++;
}
//DataTable ddt=SQLmtm.GetDataTable("")
DataTable dtt = SQLmtm.GetDataTable("SELECT\n" +
" *,\n"+
" SUBSTRING_INDEX( ap.REMARKS, ',', 1 )AS pv1,\n"+
" SUBSTRING_INDEX( ap.REMARKS, ',', -1 )AS pv2\n"+
"FROM\n" +
" a_customer_fit_r ar\n"+
" LEFT JOIN a_fit_property_p ap ON ar.ITEM_VALUE = ap.PROPERTY_VALUE \n"+
"WHERE\n" +
" FIT_COUNT_ID = '"+ Frm客户.customer_countid + "'");
foreach (Control card in change.panel4.Controls)
{
if (card is UC尺寸卡片)
{
UC尺寸卡片 c = (UC尺寸卡片)card;
foreach (DataRow dr in dtt.Rows)
{
if (dr["pv1"].ToString() == c.iTEM_VALUE || dr["pv2"].ToString() == c.iTEM_VALUE)
{
c.kehu.Text = dr["FIT_VALUE"].ToString();
c.tiaozheng.Text = dr["FIT_VALUE_CALCULATE"].ToString();
}
}
}
}
}
