/// <summary> /// 订单补充信息添加(扩展) /// </summary> /// <param name="id">id</param> /// <returns></returns> public int insertOrderExpandEst(OrderExpandModel om) { StringBuilder str = new StringBuilder(); SqlParameter[] commandParas = new SqlParameter[] { new SqlParameter("@orderno", om.orderno), new SqlParameter("@limitmax", om.limitmax), new SqlParameter("@limitper", om.limitper), new SqlParameter("@createdby", om.createdby), new SqlParameter("@createdon", om.createdon), new SqlParameter("@modifiedby", om.modifiedby), new SqlParameter("@modifiedon", om.modifiedon), new SqlParameter("@prd_dev_ms", om.prd_dev_ms), new SqlParameter("@prd_dev_adobe", om.prd_dev_adobe), new SqlParameter("@prd_dev_adsk", om.prd_dev_adsk), new SqlParameter("@prd_dev_symc", om.prd_dev_symc), new SqlParameter("@prd_dev_huawei", om.prd_dev_huawei), new SqlParameter("@prd_dev_nutanix", om.prd_dev_nutanix), new SqlParameter("@prd_dev_other", om.prd_dev_other), new SqlParameter("@prd_dev_description", om.prd_dev_description), }; str.Append("INSERT INTO [dbo].[zz_order_expand]"); str.Append("(orderno,limitmax,limitper,createdby,createdon,modifiedby,modifiedon,prd_dev_ms,prd_dev_adobe,prd_dev_adsk,prd_dev_symc,prd_dev_huawei,prd_dev_nutanix,prd_dev_other,prd_dev_description)"); str.Append(" values ("); str.Append("@orderno,@limitmax,@limitper,@createdby,@createdon,@modifiedby,@modifiedon,@prd_dev_ms,@prd_dev_adobe,@prd_dev_adsk,@prd_dev_symc,@prd_dev_huawei,@prd_dev_nutanix,@prd_dev_other,@prd_dev_description)"); int count = new DBHelper(AppSettings.NYA3Conn).ExecuteNonQuery(CommandType.Text, str.ToString(), commandParas); return(count); }
/// <summary> /// 订单补充信息更新(扩展) /// </summary> /// <param name="id">id</param> /// <returns></returns> public int updateOrderExpandEst(OrderExpandModel om) { StringBuilder str = new StringBuilder(); SqlParameter[] commandParas = new SqlParameter[] { new SqlParameter("@orderno", om.orderno), new SqlParameter("@modifiedby", om.modifiedby), new SqlParameter("@modifiedon", om.modifiedon), new SqlParameter("@prd_dev_ms", om.prd_dev_ms), new SqlParameter("@prd_dev_adobe", om.prd_dev_adobe), new SqlParameter("@prd_dev_adsk", om.prd_dev_adsk), new SqlParameter("@prd_dev_symc", om.prd_dev_symc), new SqlParameter("@prd_dev_huawei", om.prd_dev_huawei), new SqlParameter("@prd_dev_nutanix", om.prd_dev_nutanix), new SqlParameter("@prd_dev_other", om.prd_dev_other), new SqlParameter("@prd_dev_description", om.prd_dev_description), }; str.Append(@"UPDATE [dbo].[zz_order_expand] SET modifiedby=@modifiedby , modifiedon=@modifiedon,prd_dev_ms =@prd_dev_ms, prd_dev_adobe = @prd_dev_adobe,@prd_dev_adsk=prd_dev_adsk, prd_dev_symc = @prd_dev_symc,prd_dev_huawei =@prd_dev_huawei,prd_dev_nutanix=@prd_dev_nutanix, prd_dev_other = @prd_dev_other , prd_dev_description =@prd_dev_description WHERE orderno=@orderno"); int count = new DBHelper(AppSettings.NYA3Conn).ExecuteNonQuery(CommandType.Text, str.ToString(), commandParas); return(count); }
public OrderExpandModel getOrderExpandInfo(string OrderNumber) { DataTable dt = null; OrderExpandModel om = new OrderExpandModel(); StringBuilder str = new StringBuilder(); SqlParameter[] commandParas = new SqlParameter[] { new SqlParameter("@OrderNumber", OrderNumber), }; str.Append(@" SELECT [orderno] ,[checkpsn] ,[checkdt] ,[limitmax] ,[limitper] ,[isspecial] ,[remarks] ,[iscancell] ,[createdon] ,[createdby] ,[modifiedon] ,[modifiedby] ,[prd_dev_ms] ,[prd_dev_adobe] ,[prd_dev_adsk] ,[prd_dev_symc] ,[prd_dev_huawei] ,[prd_dev_nutanix] ,[prd_dev_other] ,[prd_dev_description] FROM zz_order_expand WHERE orderno = @OrderNumber"); DataSet ds = new DBHelper(AppSettings.NYA3Conn).ExecuteDataSet(CommandType.Text, str.ToString(), commandParas); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { dt = ds.Tables[0]; foreach (DataRow dr in ds.Tables[0].Rows) { om.orderno = ds.Tables[0].Rows[0]["orderno"].ToString(); om.checkpsn = ds.Tables[0].Rows[0]["checkpsn"].ToString(); om.checkdt = ds.Tables[0].Rows[0]["checkdt"].ToString(); om.limitmax = decimal.Parse(ds.Tables[0].Rows[0]["limitmax"].ToString()); om.limitper = decimal.Parse(ds.Tables[0].Rows[0]["limitper"].ToString()); om.isspecial = ds.Tables[0].Rows[0]["isspecial"].ToString() == "" ? 0 : int.Parse(ds.Tables[0].Rows[0]["isspecial"].ToString()); om.remarks = ds.Tables[0].Rows[0]["isspecial"].ToString() == "" ? "" : ds.Tables[0].Rows[0]["remarks"].ToString(); om.createdon = DateTime.Parse(ds.Tables[0].Rows[0]["createdon"].ToString()); om.createdby = ds.Tables[0].Rows[0]["createdby"].ToString(); om.modifiedon = DateTime.Parse(ds.Tables[0].Rows[0]["modifiedon"].ToString()); om.modifiedby = ds.Tables[0].Rows[0]["modifiedby"].ToString(); om.prd_dev_ms = ds.Tables[0].Rows[0]["prd_dev_ms"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_ms"].ToString()) : 0; om.prd_dev_adobe = ds.Tables[0].Rows[0]["prd_dev_adobe"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_adobe"].ToString()) : 0; om.prd_dev_adsk = ds.Tables[0].Rows[0]["prd_dev_adsk"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_adsk"].ToString()) : 0; om.prd_dev_symc = ds.Tables[0].Rows[0]["prd_dev_symc"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_symc"].ToString()) : 0; om.prd_dev_huawei = ds.Tables[0].Rows[0]["prd_dev_huawei"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_huawei"].ToString()) : 0; om.prd_dev_nutanix = ds.Tables[0].Rows[0]["prd_dev_nutanix"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_nutanix"].ToString()) : 0; om.prd_dev_other = ds.Tables[0].Rows[0]["prd_dev_other"].ToString() != "" ? decimal.Parse(ds.Tables[0].Rows[0]["prd_dev_other"].ToString()) : 0; om.prd_dev_description = ds.Tables[0].Rows[0]["prd_dev_description"].ToString(); } } else { return(null); } return(om); }