/// <summary>
/// 使用orderID返回尺寸呈现dto
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static List <尺寸呈现dto> getDto尺寸WithOrderId(String orderid)
{
String sql = "SELECT\n" +
" o_order_p.ORDER_ID,\n"+
" o_order_p.STYLE_ID,\n"+
" o_order_p.CUSTOMER_ID,\n"+
" s_style_p.STYLE_FIT_CD,\n"+
" s_style_p.STYLE_CATEGORY_CD,\n"+
" s_style_p.STYLE_SIZE_CD,\n"+
" s_style_p.STYLE_SIZE_GROUP_CD \n"+
"FROM\n" +
" o_order_p\n"+
" LEFT JOIN s_style_p ON o_order_p.STYLE_ID = s_style_p.SYS_STYLE_ID \n"+
"WHERE\n" +
" ORDER_ID = '"+ orderid + "'";
DataRow dr = SQLmtm.GetDataRow(sql);
List <尺寸呈现dto> dtos = new List <尺寸呈现dto>();
try
{
dtos = getDto尺寸ByOrderId(orderid, dr["STYLE_FIT_CD"].ToString(), dr["STYLE_CATEGORY_CD"].ToString(), dr["STYLE_SIZE_CD"].ToString(), dr["STYLE_SIZE_GROUP_CD"].ToString(), dr["CUSTOMER_ID"].ToString());
}
catch
{
}
return(dtos);
}
/// <summary>
/// 成衣尺寸数据
/// </summary>
/// <param name="styleid"></param>
/// <returns></returns>
public static List <成衣尺寸DTO> Get成衣尺寸DTO(String styleid)
{
List <成衣尺寸DTO> cycc = new List <成衣尺寸DTO>();
String sql = "SELECT\n" +
" ITEM_CD AS itemCd,\n" +
" ITEM_VALUE AS itemValue,\n" +
" FIT_VALUE AS fitValue,\n" +
" IN_VALUE AS inValue,\n" +
" OUT_VALUE AS outValue \n" +
"FROM\n" +
" s_style_fit_r \n" +
"WHERE\n" +
" STYLE_ID = '" + styleid + "'";
DataRow chengyidr = SQLmtm.GetDataRow(sql);
List <String> itemCdList = new List <String>(chengyidr["itemCd"].ToString().Split(','));
List <String> itemValueList = new List <String>(chengyidr["itemValue"].ToString().Split(','));
List <String> fitValueList = new List <String>(chengyidr["fitValue"].ToString().Split(','));
List <Tradd> itemCdHoldList = new List <Tradd>();
List <Tradd> itemValueHoldList = new List <Tradd>();
List <Tradd> fitValueHoldList = new List <Tradd>();
int i = 0;
foreach (String cdvl in itemCdList)
{
itemCdHoldList.Add(new Tradd(i, cdvl));
i++;
}
i = 0;
foreach (String cdvl in itemValueList)
{
itemValueHoldList.Add(new Tradd(i, cdvl));
i++;
}
i = 0;
foreach (String cdvl in fitValueList)
{
fitValueHoldList.Add(new Tradd(i, cdvl));
i++;
}
foreach (Tradd tradd1 in itemCdHoldList)
{
foreach (Tradd tradd2 in itemValueHoldList)
{
if (tradd1.i == tradd2.i)
{
foreach (Tradd tradd3 in fitValueHoldList)
{
if (tradd2.i == tradd3.i)
{
cycc.Add(new 成衣尺寸DTO(tradd1.str, tradd2.str, tradd3.str));
break;
}
}
break;
}
}
}
return(cycc);
}
/// <summary>
/// 获取任务,读取任务
/// </summary>
/// <param name="remark_id"></param>
public static DataRow GetTaskRead(String remark_id)
{
String sql = "SELECT\n" +
" tr.remark_id,\n"+
" tr.order_id,\n"+
" tr.remark,\n"+
" tr.file_name,\n"+
" tr.template_id,\n"+
" tr.`data`,\n"+
" tr.style_id,\n"+
" tr.ref_style_id,\n"+
" tr.CREATE_DATE,\n"+
" tr.parent_id,\n"+
" tr.version,\n"+
" tr.principal,\n"+
" tr.serial_number,\n"+
" tr.status,\n"+
" tr.A_jSON,\n" +
" tr.A_FILE,\n" +
" tt.template_name,\n"+
" ttg.template_group_id,\n"+
" ttg.template_group_name\n"+
"FROM\n" +
" t_remark AS tr\n"+
" LEFT JOIN t_template AS tt ON tr.template_id = tt.template_id\n"+
" LEFT JOIN t_template_group AS ttg ON tt.template_group_id = ttg.template_group_id \n"+
"WHERE\n" +
" tr.remark_id = '"+ remark_id + "'";
return(SQLmtm.GetDataRow(sql));
}
/// <summary>
/// 获取选择的尺码的尺寸
/// </summary>
/// <param name="size"></param>
/// <param name="styleid"></param>
/// <returns></returns>
public static DataTable StyleValue(String size, String styleid, DataTable stylesizedt)
{
DataRow st = SQLmtm.GetDataRow("SELECT * FROM s_style_p WHERE SYS_STYLE_ID = '" + styleid + "'");
DataTable dt = new DataTable();
foreach (DataRow dr in stylesizedt.Rows)
{
if (dr["尺寸"].ToString() == size)
{
String sql = "SELECT\n" +
" *,\n"+
" SUBSTRING_INDEX( SIZE_CD, '-',- 1 ) \n"+
"FROM\n" +
" `a_size_fit_p` \n"+
"WHERE\n" +
" FIT_CD = '"+ st["STYLE_FIT_CD"].ToString() + "' \n" +
" AND STYLE_CATEGORY_CD = '"+ st["STYLE_CATEGORY_CD"].ToString() + "' \n" +
" AND SIZEGROUP_CD = '"+ st["STYLE_SIZE_GROUP_CD"] + "' \n" +
" AND SIZE_CD = '"+ dr["SIZE_CD"].ToString() + "';";
dt = SQLmtm.GetDataTable(sql);
break;
}
}
return(dt);
}
/// <summary>
/// 动态保存订单
/// </summary>
/// <param name="orderDto"></param>
public static void DynamicSaveOrder(OrderDto orderDto)
{
DataRow drstyle = SQLmtm.GetDataRow("SELECT MAX(SYS_STYLE_ID) SYS_STYLE_ID FROM `s_style_p`");
orderDto.style_id = (Convert.ToInt32(drstyle["SYS_STYLE_ID"]) + 1).ToString();
//orderDto.style_id = FunctionHelper.generateBillNo("s_style_p", "SYS_STYLE_ID", "", "0000");
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[] { orderDto.style_id, "AUDIT_PHASE_CD-PHASE_CD_10", orderDto.Dto尺寸.ITEM_CD, orderDto.Dto尺寸.ITEM_VALUE, orderDto.Dto尺寸.FIT_VALUE, orderDto.Dto尺寸.FM_VALUE, "0", "1", "46", orderDto.Dto尺寸.IN_VALUE, orderDto.Dto尺寸.OUT_VALUE }
);
SQLmtm.DoInsert(
"a_customer_fit_value_r"
, new string[] { "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }
, new string[] { orderDto.CUSTOMER_ID, orderDto.CUSTOMER_NAME, orderDto.Dto尺寸.ITEM_CD, orderDto.Dto尺寸.ITEM_VALUE, orderDto.Dto尺寸.FIT_VALUE, orderDto.Dto尺寸.FM_VALUE, orderDto.Dto尺寸.IN_VALUE, orderDto.Dto尺寸.OUT_VALUE, "0", "0", orderDto.CUSTOMER_COUNT_ID }
);
SQLmtm.DoInsert(
"s_style_p"
, new string[] { "SYS_STYLE_ID", "SHOP_ID", "STYLE_CD", "STYLE_KBN", "STYLE_CATEGORY_CD", "SYTLE_FABRIC_ID", "STYLE_SIZE_GROUP_CD", "STYLE_SIZE_CD", "STYLE_MAKE_TYPE", "ENABLE_FLAG", "DELETE_FLAG", "VERSION", "STYLE_NAME_CN", "REMARKS", "CUSTOMER_COUNT_ID", "STYLE_FIT_CD", "REF_STYLE_ID", "STYLE_DRESS_CATEGORY", "STYLE_DESIGN_TYPE", "STYLE_PUBLISH_CATEGORY_CD", "SYTLE_YEAR", "SYTLE_SEASON" }
, new string[] { orderDto.style_id, "18", "", "STYLE_SOURCE-STYLE_SOURCE_50", orderDto.STYLE_CATEGORY_CD, orderDto.SYTLE_FABRIC_ID, orderDto.STYLE_SIZE_GROUP_CD, orderDto.STYLE_SIZE_CD, "4SMA-4M", "1", "0", "1", orderDto.STYLE_NAME_CN, "", orderDto.CUSTOMER_COUNT_ID, orderDto.STYLE_FIT_CD, orderDto.REF_STYLE_ID, orderDto.STYLE_DRESS_CATEGORY, orderDto.STYLE_DESIGN_TYPE, orderDto.STYLE_PUBLISH_CATEGORY_CD, orderDto.SYTLE_YEAR, orderDto.SYTLE_SEASON }
);
foreach (Dto设计点 dto in orderDto.Dto设计点s)
{
SQLmtm.DoInsert("s_style_option_r", new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" }, new string[] { orderDto.style_id, dto.ITEM_CD, dto.ITEM_VALUE, dto.OPTION_VALUE, "1", "0" });
}
RestCall.httpGetMethod("https://shirtmtm.com/fragsmart-mtm/customer/update/payment?styleId=" + orderDto.style_id + "&customerId=" + orderDto.CUSTOMER_ID + "&addressId=" + orderDto.ADDRESS_ID + "&number=" + orderDto.ORDER_NUMBER);
//RestCall.httpGetMethod("http://localhost:8080/customer/update/payment?styleId=" + orderDto.style_id + "&customerId=" + orderDto.CUSTOMER_ID + "&addressId=" + orderDto.ADDRESS_ID + "&number=" + orderDto.ORDER_NUMBER);
DataRow ORDER_ID = SQLmtm.GetDataRow("SELECT MAX(ORDER_ID) AS ORDER_ID FROM `o_order_p`");
int order_id = Convert.ToInt32(ORDER_ID["ORDER_ID"]);
//order_id++;
SQLmtm.DoInsert("o_order_brand_r", new string[] { "OGNIZATION_ID", "SHOP_ID", "BRAND_ID", "ORDER_ID" }, new string[] { "95", "18", "", order_id.ToString() });
SQLmtm.DoInsert("t_order_type", new string[] { "ORDER_ID", "ORDER_TYPE" }, new string[] { order_id.ToString(), "1" });
}
/// <summary>
/// 取得设计点中文名
/// </summary>
/// <param name="itemValue"></param>
/// <returns></returns>
public static String GetNameCN(String itemValue)
{
DataRow dr = SQLmtm.GetDataRow("SELECT PROPERTY_NAME_CN FROM a_fit_property_p WHERE PROPERTY_VALUE='" + itemValue + "'");
if (dr == null)
{
return("");
}
else
{
return(dr["PROPERTY_NAME_CN"].ToString());
}
}
/// <summary>
/// 根据id取面料信息
/// </summary>
/// <param name="SYTLE_FABRIC_ID"></param>
/// <returns></returns>
public static DataRow generateMaterialInfo(String SYTLE_FABRIC_ID)
{
String sql = "SELECT\n" +
" MATERIAL_ID,\n"+
" MATERIAL_NAME_CN,\n"+
" MATERIAL_COLOR \n"+
"FROM\n" +
" i_material_p \n"+
"WHERE\n" +
" MATERIAL_ID = '"+ SYTLE_FABRIC_ID + "'";
return(SQLmtm.GetDataRow(sql));
}
/*
* public static void uploadTaskFile(String taskId, String empId)
* {
* OpenFileDialog ofd = new OpenFileDialog();
* ofd.Title = "请选择文件";
* ofd.Filter = "(*xlsx;*.xls;*.docx;*.doc;*.pdf)|*xlsx;*.xls;*.docx;*.doc;*.pdf";
* //ofd.ShowDialog();
* if (ofd.ShowDialog() == DialogResult.OK)
* {
* Byte[] byteArray = FileBinaryConvertHelper.File2Bytes(ofd.FileName);
* String fileStr = Convert.ToBase64String(byteArray);
*
* String uuid = System.Guid.NewGuid().ToString("N");
* string sql = "insert into file (id,filename,file)"
+ " values('" + uuid + "'"
+ " , '" + ofd.SafeFileName + "'"
+ " , '" + fileStr + "'); ";
+ DBUtil.ExecuteSQL(sql);
+ sql = "update custom_appointment_assignee"
+ " set file_id = '" + uuid + "'"
+ " , status = '" + (int)EnumAssignment.已完成 + "'"
+ " where task_id = '" + taskId + "' and emp_id = '" + empId + "'; ";
+ int i = DBUtil.ExecuteSQL(sql);
+ //int i = DocService.UpdataMoBan(str, ofd.SafeFileName, fileName);
+ if (i != 0)
+ {
+ MessageBox.Show("上传成功");
+ }
+ }
+ }*/
/// <summary>
/// 保存备注文档
/// </summary>
/// <param name="file"></param>
/// <param name="fileName"></param>
/// <param name="orderid"></param>
public static void SaveRemarkFile(String file, String fileName, String orderid)
{
String sql = "SELECT * FROM t_remark WHERE order_id='" + orderid + "'";
if (SQLmtm.GetDataRow(sql) == null)
{
SQLmtm.DoInsert("t_remark", new string[] { "order_id", "remark", "file_name" }, new string[] { orderid, file, fileName });
}
else
{
SQLmtm.DoUpdate("t_remark", new string[] { "remark" }, new string[] { file }, new string[] { "order_id" }, new string[] { orderid });
}
}
/// <summary>
/// 面料打印log信息写入
/// </summary>
/// <param name="id"></param>
public static void InsertMianLiaoLog(String id)
{
DataRow dr = SQLmtm.GetDataRow("SELECT\n" +
" * \n"+
"FROM\n" +
" t_material_log \n"+
"WHERE\n" +
" material_id = "+ id + ";");
if (dr == null)
{
SQLmtm.DoInsert("t_material_log", new string[] { "material_id", "enable_flag" }, new string[] { id, "1" });
}
}
/// <summary>
/// 根据标准款取款式信息
/// </summary>
/// <param name="REF_STYLE_ID"></param>
/// <returns></returns>
public static DataRow generateStyleInfo(String REF_STYLE_ID)
{
String sql = "SELECT\n" +
" SYS_STYLE_ID,\n"+
" STYLE_SIZE_CD,\n"+
" STYLE_NAME_CN,\n"+
" SYTLE_YEAR,STYLE_DRESS_CATEGORY,STYLE_DESIGN_TYPE,\n"+
" ( CASE `s_style_p`.`SYTLE_SEASON` WHEN 'SEASON-SEASON_10' THEN '春季' WHEN 'SEASON-SEASON_20' THEN '秋季' ELSE `s_style_p`.`SYTLE_SEASON` END ) AS `SYTLE_SEASON`,\n"+
" ( CASE `s_style_p`.`STYLE_PUBLISH_CATEGORY_CD` WHEN 'PUBLISH_STYLE_CATEGORY-MShirt' THEN '男士衬衫' WHEN 'PUBLISH_STYLE_CATEGORY-WShirt' THEN '女式衬衫' ELSE `s_style_p`.`STYLE_PUBLISH_CATEGORY_CD` END ) AS `STYLE_PUBLISH_CATEGORY_CD` \n"+
"FROM\n" +
" s_style_p \n"+
"WHERE\n" +
" SYS_STYLE_ID = '"+ REF_STYLE_ID + "'";
return(SQLmtm.GetDataRow(sql));
}
/// <summary>
/// 通过订单id取订单ORDER_NO
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static String GetOrderNoWithOrderid(String orderid)
{
String sql = "SELECT\n" +
" ORDER_NO\n"+
"FROM\n" +
" o_order_p \n"+
"WHERE\n" +
" ORDER_ID = '"+ orderid + "'";
try
{
return(SQLmtm.GetDataRow(sql)["ORDER_NO"].ToString());
}
catch
{
return("");
}
}
/// <summary>
/// 通过订单id取订单STYLE_BAR_CODE
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static String GetSBCWithOrderid(String orderid)
{
String sql = "SELECT\n" +
" SUBSTRING_INDEX( ORDER_NO, '.',- 1 ) AS STYLE_BAR_CODE\n"+
"FROM\n" +
" o_order_p \n"+
"WHERE\n" +
" ORDER_ID = '"+ orderid + "'";
try
{
return(SQLmtm.GetDataRow(sql)["STYLE_BAR_CODE"].ToString());
}
catch
{
return("");
}
}
/// <summary>
/// 校验订单
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static Boolean VerifyOrder(String orderid)
{
DataRow dr = SQLmtm.GetDataRow("SELECT\n" +
" * \n"+
"FROM\n" +
" o_order_p \n"+
"WHERE\n" +
" ORDER_ID = '"+ orderid + "'");
if (dr == null)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 取款式信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DataRow GetDataRowFromOrder(String id)
{
String sql = "SELECT\n" +
" sp.SYS_STYLE_ID,\n"+
" sp.STYLE_NAME_CN,\n"+
" imp.MATERIAL_CODE,\n"+
" imp.MATERIAL_COMPOSITION,\n"+
" sp.STYLE_SHOP_TOTAL_PRICE,\n"+
" sp.STYLE_FIT_CD,\n"+
" sp.STYLE_CATEGORY_CD,\n"+
" sp.STYLE_SIZE_GROUP_CD,sp.STYLE_SIZE_CD,SUBSTRING_INDEX( sp.STYLE_SIZE_CD, '-',- 1 ) AS SIZE\n"+
"FROM\n" +
" s_style_p AS sp\n"+
" LEFT JOIN i_material_p imp ON sp.SYTLE_FABRIC_ID = imp.MATERIAL_ID \n"+
"WHERE\n" +
" sp.SYS_STYLE_ID IN ( SELECT op.STYLE_ID FROM o_order_p AS op WHERE ORDER_NO like '%"+ id + "%' );";
return(SQLmtm.GetDataRow(sql));
}
/// <summary>
/// 通过orderid取styleid
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static String GetStyleidWithOrderid(String orderid)
{
String sql = "SELECT\n" +
" ORDER_ID,\n"+
" STYLE_ID \n"+
"FROM\n" +
" o_order_p \n"+
"WHERE\n" +
" ORDER_ID = '"+ orderid + "'";
try
{
DataRow dataRow = SQLmtm.GetDataRow(sql);
return(dataRow["STYLE_ID"].ToString());
}
catch
{
return("");
}
}
private void stylechangesave_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("确认保存吗？", "保存", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
if (this.shuliang.Text == "" || this.mianliaoname.Text == "" || this.chicun01.Text == "")
{
MessageBox.Show("请填写完整");
return;
}
try
{
Frm定制下单修改尺寸.styleid = StyleService.GetNewStyleID();
//尺寸保存
ImpService.StandardModelsSizeSive(this.chooseStyleSize);
//s_style_p写入数据
ImpService.insertS_Style_P(styleCard);
//设计点保存
ImpService.StandardModelsDesignSive();
//o_order_p写入数据
//RestCall.httpGetMethod("https://shirtmtm.com/fragsmart-mtm/customer/update/payment?styleId=" + styleid.ToString() + "&customerId=" + CreateCustomer.cUSTOMER_ID.ToString() + "&addressId=" + CreateCustomer.aDDRESS_ID.ToString() + "&number=" + this.shuliang.Text);
RestCall.httpGetMethod("http://localhost:8080/customer/update/payment?styleId=" + Frm定制下单修改尺寸.styleid.ToString() + "&customerId=" + Frm客户.cUSTOMER_ID.ToString() + "&addressId=" + Frm客户.aDDRESS_ID.ToString() + "&number=" + this.shuliang.Text);
DataRow ORDER_ID = SQLmtm.GetDataRow("SELECT MAX(ORDER_ID) AS ORDER_ID FROM `o_order_p`");
int order_id = Convert.ToInt32(ORDER_ID["ORDER_ID"]);
//order_id++;
SQLmtm.DoInsert("o_order_brand_r", new string[] { "OGNIZATION_ID", "SHOP_ID", "BRAND_ID", "ORDER_ID" }, new string[] { "95", "18", "", order_id.ToString() });
SQLmtm.DoInsert("t_order_type", new string[] { "ORDER_ID", "ORDER_TYPE" }, new string[] { order_id.ToString(), "2" });
MessageBox.Show("保存成功");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
return;
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
DataRow dr = SQLmtm.GetDataRow("SELECT * FROM a_noorder_print_p WHERE clothes_log_id='" + this.tiaomaid.Text.Trim() + "';");
if (e.KeyValue == 13) //判断是回车键
{
try
{
List <Grid2information> grid2Information = new List <Grid2information>();
grid2Information.Add(new Grid2information("店铺", SQLmtm.GetDataRow("SELECT * FROM t_shop WHERE shop_id='" + dr["shop_id"].ToString() + "'")["shop_name"].ToString()));
grid2Information.Add(new Grid2information("styleid", dr["style_id"].ToString()));
grid2Information.Add(new Grid2information("款式名称", SQLmtm.GetDataRow("SELECT STYLE_NAME_CN FROM s_style_p WHERE SYS_STYLE_ID='" + dr["style_id"].ToString() + "'")["STYLE_NAME_CN"].ToString()));
grid2Information.Add(new Grid2information("面料id", dr["materials_id"].ToString()));
grid2Information.Add(new Grid2information("面料号", FabricService.GetMianLiaoCD(dr["materials_id"].ToString(), "dd")));
grid2Information.Add(new Grid2information("尺寸", dr["size_cd"].ToString()));
this.gridControl2.DataSource = grid2Information;
this.gridControl2.Refresh();
}
catch
{
}
}
}
/// <summary>
/// 获得款式所有尺码
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public static DataTable StyleCombobox(String styleid)
{
DataRow dr = SQLmtm.GetDataRow("SELECT SYS_STYLE_ID,SHOP_ID,STYLE_NO,CUSTOMER_COUNT_ID,STYLE_CD,STYLE_KBN,STYLE_SOURCE,STYLE_CATEGORY_CD,STYLE_DRESS_CATEGORY,STYLE_DESIGN_TYPE,STYLE_PUBLISH_CATEGORY_CD,REF_STYLE_ID,STYLE_NAME_CN,STYLE_NAME_EN,STYLE_FIT_CD,SYTLE_YEAR,SYTLE_SEASON,SYTLE_FABRIC_ID,SYTLE_FABRIC_NO,STYLE_COMPOSITION,STYLE_DESCRIBE,STYLE_COLOR_CD,STYLE_COLOR_NAME,STYLE_SIZE_GROUP_CD,STYLE_SIZE_CD,STYLE_MAKE_TYPE,STYLE_FIT_BODY_TYPE,STYLE_SEX_CD,STYLE_STANDARD,STYLE_BAR_CODE,STYLE_DESIGNER_DATE,STYLE_DESIGNER,STYLE_MATERIAL_NUMBER,STYLE_DESIGN_PRICE,STYLE_FACTORY_TOTAL_PRICE,STYLE_SHOP_TOTAL_PRICE,REMARKS,ENABLE_FLAG,DELETE_FLAG,VERSION,CREATE_DATE,UPDATE_DATE,CREATE_USER,UPDATE_USER,COVER_PHOTO_PATH FROM s_style_p WHERE SYS_STYLE_ID = '" + styleid + "'");
DataTable dt = new DataTable();
try
{
String sql = " SELECT\n" +
"-- *,\n"+
" DISTINCT SIZE_CD,\n" +
" SUBSTRING_INDEX( SIZE_CD, '-',- 1 ) AS 尺寸\n" +
"FROM\n" +
" `a_size_fit_p` \n"+
"WHERE\n" +
" FIT_CD = '"+ dr["STYLE_FIT_CD"].ToString() + "' \n" +
" AND STYLE_CATEGORY_CD = '"+ dr["STYLE_CATEGORY_CD"].ToString() + "' \n" +
" AND SIZEGROUP_CD = '"+ dr["STYLE_SIZE_GROUP_CD"] + "';";
dt = SQLmtm.GetDataTable(sql);
}
catch
{
}
return(dt);
}
private void searchLookUpEdit1View_Click(object sender, EventArgs e)
{
var a = this.searchLookUpEdit1.Properties.View.GetSelectedRows();
foreach (int rowHandle in a)
{
Frm客户.cUSTOMER_ID // no
= Convert.ToInt32(this.searchLookUpEdit1.Properties.View.GetRowCellValue(rowHandle, "ID").ToString()); //id 是 Value Member
Frm客户.customer_name // no
= this.searchLookUpEdit1.Properties.View.GetRowCellValue(rowHandle, "客户姓名").ToString(); //id 是 Value Member
}
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 ='" + Frm客户.cUSTOMER_ID + "' AND DEFAULT_FLAG ='1') s2 on s1.FIT_COUNT_ID=s2.ID");
if (dt.Rows.Count != 0)
{
DataRow drr = SQLmtm.GetDataRow("SELECT * FROM `a_customer_fit_count_r` WHERE CUSTOMER_ID='" + Frm客户.cUSTOMER_ID.ToString() + "' AND DEFAULT_FLAG=1");
DataRow ddr = SQLmtm.GetDataRow("SELECT * FROM `a_customer_address_p` WHERE CUSTOMER_ID='" + Frm客户.cUSTOMER_ID.ToString() + "'");
if (drr == null || ddr == null)
{
Frm客户.cUSTOMER_ID = 0;
Frm客户.customer_name = "";
MessageBox.Show("缺少客户信息");
return;
}
Frm客户.customer_countid = Convert.ToInt32(drr["ID"]);
Frm客户.aDDRESS_ID = Convert.ToInt32(ddr["ADDRESS_ID"]);
}
else
{
Frm客户.cUSTOMER_ID = 0;
Frm客户.customer_name = "";
MessageBox.Show("选择的客户未建立量体值");
return;
}
this.gridControl2.DataSource = CustomerService.GetCustomerInformation(Frm客户.cUSTOMER_ID);
}
public static DataRow GetMianLiaoDR(String id)
{
String sql = "SELECT\n" +
" *,CONCAT(s1.materialCode,':',s1.materialNameCn) AS mianliao,\n"+
"SUBSTRING_INDEX( s1.filePath, '/',- 1 ) AS picn,s1.materialCode,s1.materialComposition,\n" +
" CONCAT( 'https://sshirtmtmbucket.oss-cn-zhangjiakou.aliyuncs.com/sshirtmtm/', SUBSTRING_INDEX( s1.filePath, '/',- 1 ) ) AS picurl \n"+
"FROM\n" +
" (\n"+
" SELECT\n"+
" a.material_id AS \"id\",\n"+
" a.material_file_id AS \"fileId\",\n"+
" a.material_name_cn AS \"materialNameCn\",\n"+
" a.material_name_en AS \"materialNameEn\",\n"+
" a.material_code AS \"materialCode\",\n"+
" a.material_use_type AS \"materialUseType\",\n"+
" a.material_type_cd AS \"materialTypeCd\",\n"+
" a.material_composition AS \"materialComposition\",\n"+
" a.material_spec AS \"materialSpec\",\n"+
" a.material_unit_cd AS \"materialUnitCd\",\n"+
" a.material_year AS \"materialYear\",\n"+
" a.material_color AS \"materialColor\",\n"+
" a.material_season AS \"materialSeason\",\n"+
" a.remarks AS \"remarks\",\n"+
" a.material_category AS \"materialStyleCategory\",\n"+
" a.model_filepath AS \"modelFilepath\",\n"+
" CASE\n"+
" \n"+
" WHEN file.FILE_PATH IS NOT NULL \n"+
" AND file.FILE_PATH != '' THEN\n"+
" REPLACE ( CONCAT( file.FILE_PATH, file.UPLOAD_FILE ), 'fragsmart-erp', 'fragsmart-mtm' ) ELSE REPLACE ( CONCAT( upload_file.FILE_PATH, upload_file.UPLOAD_FILE ), 'fragsmart-erp', 'fragsmart-mtm' ) \n"+
" END AS filePath,\n"+
" a_login_user_p.LAST_NAME AS \"createby.lastName\",\n"+
" a_login_user_p.FIRST_NAME AS \"createby.firstName\",\n"+
" IFNULL( s.material_sale_price, 0 ) AS \"materialPrice.materialSalePrice\",\n"+
" IFNULL( inventory_material.MATERIAL_QUANTITY, 0 ) AS \"inventoryMaterial.materialQuantity\",\n"+
" a.MATERIAL_LEVEL AS \"materialLevel\",\n"+
" a.MATERIAL_STYLE AS \"materialStyle\",\n"+
" a.MATERIAL_WEAVE AS \"materialWeave\",\n"+
" CASE\n"+
" \n"+
" WHEN adp.ITEM_VALUE = \"A_150\" THEN\n"+
" 150 \n"+
" WHEN adp.ITEM_VALUE = \"B_180\" THEN\n"+
" 180 \n"+
" WHEN adp.ITEM_VALUE = \"C_240\" THEN\n"+
" 240 \n"+
" WHEN adp.ITEM_VALUE = \"D_320\" THEN\n"+
" 320 ELSE 0 \n"+
" END AS \"materiaFacPrice\" \n"+
" FROM\n"+
" i_material_p a\n"+
" LEFT JOIN a_shop_material_r ar ON a.MATERIAL_ID = ar.MATERIAL_ID\n"+
" LEFT JOIN a_login_user_p a_login_user_p ON a_login_user_p.login_user_id = a.create_user\n"+
" LEFT JOIN i_material_price_s s ON s.material_id = a.material_id \n"+
" AND s.SHOP_ID = 18\n"+
" INNER JOIN i_inventory_material_p inventory_material ON inventory_material.material_id = a.material_id\n"+
" LEFT JOIN w_upload_file_p file ON a.material_file_id = file.FILE_ID \n"+
" AND file.FTP_FILE = \"/material\"\n"+
" LEFT JOIN a_upload_file_p upload_file ON upload_file.FILE_ID = a.MATERIAL_FILE_ID \n"+
" AND upload_file.FILE_KBN = 0 \n"+
" AND upload_file.FTP_FILE = \"/material\"\n"+
" LEFT JOIN a_dict_p adp ON a.MATERIAL_LEVEL = CONCAT( adp.ITEM_CD, \"-\", adp.ITEM_VALUE ) \n"+
" WHERE\n"+
" a.delete_flag = 0 \n"+
" AND a.material_category IN ( 'MATERIAL_CATEGORY-Fabric', 'MATERIAL_CATEGORY-ButtonL', 'MATERIAL_CATEGORY-Suit_Fabric', 'MATERIAL_CATEGORY-Suit_Material' ) \n"+
" AND ar.SHOP_ID = 18 AND a.MATERIAL_ID ='"+ id + "'\n" +
//" AND ( a.material_name_cn LIKE '%" + mlname + "%' OR a.material_code LIKE '%" + mlname + "%' ) \n" +
" AND a.material_category ='MATERIAL_CATEGORY-Fabric'" +
" ORDER BY\n"+
" a.MATERIAL_CATEGORY,\n"+
" a.MATERIAL_ID \n"+
" ) AS s1";
return(SQLmtm.GetDataRow(sql));
}
/// <summary>
/// 获得最新的styleid
/// </summary>
/// <returns></returns>
public static int GetNewStyleID()
{
DataRow drstyle = SQLmtm.GetDataRow("SELECT MAX(SYS_STYLE_ID) SYS_STYLE_ID FROM `s_style_p`");
return(Convert.ToInt32(drstyle["SYS_STYLE_ID"]) + 1);
}
/// <summary>
/// 根据名字取图片
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public static Image GetImage(String value)
{
String sql = "SELECT \n" +
" s1.itemValue , \n" +
" s1.itemNameCn , \n" +
" s1.itemCode , \n" +
" S2.UPLOAD_FILE AS picn, \n" +
" s2.picurl \n" +
" FROM \n" +
" ( \n" +
" SELECT \n" +
" ap.ITEM_VALUE itemValue, \n" +
" ap.DESIGN_ID id, \n" +
" CONCAT( ap.ITEM_VALUE, \":\", ap.ITEM_NAME_CN ) itemNameCn, \n" +
" ap.ITEM_CD itemCode, \n" +
" adp.ITEM_CD itemParentCode \n" +
" FROM \n" +
" a_designoption_p ap \n" +
" LEFT JOIN a_designoption_p adp ON adp.ITEM_VALUE = ap.ITEM_CD \n" +
" LEFT JOIN a_ognization_desgin_r adr ON ap.DESIGN_ID = adr.DESGIN_ID \n" +
" WHERE \n" +
" ( ap.ITEM_CATEGORY_CD = \"\" OR ap.ITEM_CATEGORY_CD IS NULL ) \n" +
" AND ap.STYLE_CATEGORY_CD = 'STYLE_CATEGORY-SHIRT' \n" +
" -- AND ap.ITEM_CD = '' -- AND ap.ITEM_CD IN ( SELECT ap.ITEM_VALUE itemValue FROM a_designoption_p ap WHERE ap.ITEM_CATEGORY_CD ='ITEM_TYPE_CD-10' ) \n" +
" AND ap.ITEM_VALUE = '" + value + "'\n" +
" AND adr.OGNIZATION_ID = 95 \n" +
" AND ap.ITEM_VALUE IN ( \n" +
" SELECT \n" +
" ap.ITEM_VALUE itemValue \n"+
" FROM \n" +
" a_designoption_p ap \n"+
" WHERE \n" +
" ap.DESIGN_ID IN ( SELECT ar.DESGIN_ID FROM a_shop_desgin_r ar WHERE ar.SHOP_ID = 18 ) \n"+
" ) \n" +
" ORDER BY \n" +
" ap.ITEM_CD, \n" +
" ap.ITEM_SORT ASC \n" +
" ) AS s1 \n" +
" LEFT JOIN ( \n" +
" SELECT \n" +
" a.ITEM_CD, \n" +
" a.ITEM_VALUE, \n" +
" a.ITEM_NAME_CN, \n" +
" CONCAT( 'https://sshirtmtmbucket.oss-cn-zhangjiakou.aliyuncs.com/sshirtmtm/', w.UPLOAD_FILE ) AS picurl, \n" +
" w.* \n" +
" FROM \n" +
" a_designoption_p a \n" +
" LEFT JOIN w_upload_file_p w ON a.FILE_ID = w.FILE_ID \n" +
" WHERE \n" +
" a.FILE_ID IS NOT NULL \n" +
" ) AS s2 ON s1.itemCode = s2.ITEM_CD \n" +
" AND s1.itemValue = s2.ITEM_VALUE";
DataRow dr = SQLmtm.GetDataRow(sql);
String strRtn;
try
{
strRtn = dr["picn"].ToString();
}
catch
{
strRtn = "SSHIRT.jpg";
}
return(Image.FromFile(@"pic\" + strRtn));
}
