/// <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);
}
