Exemplo n.º 1
0
        void UCPurchaseOrderView_SaveEvent(object sender, EventArgs e)
        {
            try
            {
                List <SysSQLString> listSql      = new List <SysSQLString>();
                SysSQLString        sysStringSql = new SysSQLString();
                sysStringSql.cmdType = CommandType.Text;
                Dictionary <string, string> dic = new Dictionary <string, string>();//参数

                string sql1 = string.Format(@" Update tb_parts_purchase_order Set is_suspend=@is_suspend,suspend_reason=@suspend_reason,update_by=@update_by,
                update_name=@update_name,update_time=@update_time,operators=@operators,operator_name=@operator_name where order_id=@order_id;");
                dic.Add("is_suspend", chkis_suspend.Checked ? "0" : "1");//选中(中止):0,未选中(不中止):1
                dic.Add("suspend_reason", txtsuspend_reason.Caption.Trim());
                dic.Add("update_by", GlobalStaticObj.UserID);
                dic.Add("update_name", GlobalStaticObj.UserName);
                dic.Add("update_time", Common.LocalDateTimeToUtcLong(DateTime.Now).ToString());
                dic.Add("operators", GlobalStaticObj.UserID);
                dic.Add("operator_name", GlobalStaticObj.UserName);
                dic.Add("order_id", orderId);
                sysStringSql.sqlString = sql1;
                sysStringSql.Param     = dic;
                listSql.Add(sysStringSql);
                foreach (DataGridViewRow dr in gvPurchaseList.Rows)
                {
                    string is_suspend = "1";
                    if (dr.Cells["is_suspend"].Value == null)
                    {
                        is_suspend = "1";
                    }
                    if ((bool)dr.Cells["is_suspend"].EditedFormattedValue)
                    {
                        is_suspend = "0";
                    }
                    else
                    {
                        is_suspend = "1";
                    }

                    sysStringSql         = new SysSQLString();
                    sysStringSql.cmdType = CommandType.Text;
                    dic = new Dictionary <string, string>();
                    dic.Add("is_suspend", is_suspend);
                    dic.Add("order_id", orderId);
                    dic.Add("parts_code", dr.Cells["parts_code"].Value.ToString());
                    string sql2 = "Update tb_parts_purchase_order_p set is_suspend=@is_suspend where order_id=@order_id and parts_code=@parts_code;";
                    sysStringSql.sqlString = sql2;
                    sysStringSql.Param     = dic;
                    listSql.Add(sysStringSql);
                }
                if (DBHelper.BatchExeSQLStringMultiByTrans("修改采购订单", listSql))
                {
                    MessageBoxEx.Show("保存成功!");
                    uc.BindgvPurchaseOrderList();
                    deleteMenuByTag(this.Tag.ToString(), uc.Name);
                }
                else
                {
                    MessageBoxEx.Show("保存失败!");
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show("操作失败!");
            }
        }