public static void save设计点(String Style_Id, Dto尺寸 Dto尺寸) { SQLmtm.DoUpdate( "s_style_fit_r" , new string[] { "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" } , new string[] { "AUDIT_PHASE_CD-PHASE_CD_10", Dto尺寸.ITEM_CD, Dto尺寸.ITEM_VALUE, Dto尺寸.FIT_VALUE, Dto尺寸.FM_VALUE, "0", "1", "46", Dto尺寸.IN_VALUE, Dto尺寸.OUT_VALUE } , new string[] { "STYLE_ID" } , new string[] { Style_Id } ); }
public static List <尺寸呈现dto> getDto尺寸ByOrderId(String orderId, String STYLE_FIT_CD, String STYLE_CATEGORY_CD, String STYLE_SIZE_CD, String STYLE_SIZE_GROUP_CD, String CUSTOMER_ID) { // 尺寸 String sql = "SELECT\n" + " STYLE_ID,\n"+ " PHASE_CD,\n"+ " ITEM_CD,\n"+ " ITEM_VALUE,\n"+ " FIT_VALUE,\n"+ " FM_VALUE,\n"+ " DELETE_FLAG,\n"+ " VERSION,\n"+ " CREATE_USER,\n"+ " IN_VALUE,\n"+ " OUT_VALUE \n"+ "FROM\n" + " s_style_fit_r \n"+ "WHERE\n" + " STYLE_ID IN ( SELECT STYLE_ID FROM o_order_p WHERE ORDER_ID = '"+ orderId + "' );"; DataTable dt = SQLmtm.GetDataTable(sql); // 客户量体值 sql = "SELECT\n" + " customer_fit.CUSTOMER_FIT_ID,\n" + " customer_fit.CUSTOMER_ID,\n" + " customer_fit.STYLE_CATEGORY_CD,\n" + " customer_fit.ITEM_CD,\n" + " customer_fit.ITEM_VALUE,\n" + " customer_fit.FIT_VALUE,\n" + " property.PROPERTY_NAME_CN,\n" + " property.PROPERTY_CD,\n" + " property.PROPERTY_VALUE,\n" + " property.PROPERTY_UNIT_CD,\n" + " customer_fit.STYLE_CATEGORY_CD \n" + "FROM\n" + " a_customer_fit_r customer_fit\n" + " LEFT JOIN a_fit_property_p property ON property.PROPERTY_CD = customer_fit.ITEM_CD \n" + " AND property.PROPERTY_VALUE = customer_fit.ITEM_VALUE \n" + "WHERE\n" + " customer_fit.DELETE_FLAG = 0 \n" + " AND customer_fit.CUSTOMER_ID = '" + CUSTOMER_ID + "' \n" + " AND customer_fit.CREATE_DATE = ( SELECT CREATE_DATE FROM a_customer_fit_r WHERE CUSTOMER_ID = '" + CUSTOMER_ID + "' ORDER BY CREATE_DATE DESC LIMIT 1 ) \n" + "ORDER BY\n" + " property.PROPERTY_COST"; DataTable dataTable客户量体值 = SQLmtm.GetDataTable(sql); sql = "select Garment_size,Customer_measurement from garmentsize_to_customermeasurement;"; DataTable dataTable对应关系 = SQLmtm.GetDataTable(sql); Dictionary <String, String> sizePairs = new Dictionary <string, string>(); // 量体制对应关系 foreach (DataRow dataRow in dataTable对应关系.Rows) { sizePairs.Add(dataRow["Garment_size"].ToString(), dataRow["Customer_measurement"].ToString()); } Dto尺寸 Dto尺寸; foreach (DataRow dr in dt.Rows) { Dto尺寸 = new Dto尺寸(dr); List <尺寸呈现dto> 尺寸呈现dto = SizeService.GetThisSize(STYLE_FIT_CD, STYLE_CATEGORY_CD, STYLE_SIZE_CD, STYLE_SIZE_GROUP_CD, dr["STYLE_ID"].ToString(), false); Dto尺寸.build尺寸呈现dto(尺寸呈现dto, dataTable客户量体值, sizePairs); return(尺寸呈现dto); } throw new Exception("没有量体值"); }