/// <summary>
        /// 编辑情况下组装sql的方法
        /// </summary>
        /// <param name="listSql"></param>
        /// <param name="purchase_billing_id"></param>
        /// <param name="model"></param>
        private void EditReceiptBillSql(List <SysSQLString> listSql, tb_parts_stock_shipping stockShippingEntity, string StockShippingtId, string HandleType)
        {
            try
            {
                const string NoDelFlag = "1";                                                                  //默认删除标记,1表示未删除,0表示删除
                string       Save      = DataSources.GetDescription(DataSources.EnumOperateType.save, true);   //保存操作
                string       Submit    = DataSources.GetDescription(DataSources.EnumOperateType.submit, true); //提交操作
                SysSQLString sysStrSql = new SysSQLString();
                sysStrSql.cmdType = CommandType.Text;                                                          //sql字符串语句执行函数
                Dictionary <string, string> dicParam = new Dictionary <string, string>();                      //参数
                CommonFuncCall.FillEntityByControls(this, ShippingBillEntity);

                stockShippingEntity.handle      = GlobalStaticObj.UserID;
                stockShippingEntity.operators   = GlobalStaticObj.UserID;
                stockShippingEntity.enable_flag = NoDelFlag;
                if (HandleType == Save)
                {
                    stockShippingEntity.order_status      = Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
                    stockShippingEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
                }
                else if (HandleType == Submit)
                {
                    stockShippingEntity.order_status      = Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString();
                    stockShippingEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
                }
                if (ShippingBillEntity != null)
                {
                    StringBuilder sb = new StringBuilder();
                    sb.Append(" Update tb_parts_stock_shipping Set ");
                    bool isFirstValue = true;
                    foreach (PropertyInfo info in stockShippingEntity.GetType().GetProperties())
                    {
                        string name  = info.Name;
                        object value = info.GetValue(stockShippingEntity, null);
                        if (isFirstValue)
                        {
                            isFirstValue = false;
                            sb.Append(name);
                            sb.Append("=");
                            sb.Append("@" + name);
                        }
                        else
                        {
                            sb.Append("," + name);
                            sb.Append("=");
                            sb.Append("@" + name);
                        }
                        dicParam.Add(name, value == null ? "" : value.ToString());
                    }
                    sb.Append(" where stock_shipping_id='" + StockShippingtId + "';");
                    sysStrSql.sqlString = sb.ToString();
                    sysStrSql.Param     = dicParam;
                    listSql.Add(sysStrSql);//完成SQL语句的拼装
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }
        /// <summary>
        /// 添加情况下组装sql的方法
        /// </summary>
        /// <param name="listSql"></param>
        /// <param name="purchase_billing_id"></param>
        private void AddShippingBillSql(List <SysSQLString> listSql, tb_parts_stock_shipping stockShippingEntity, string StockShippingId, string HandleType)
        {
            try
            {
                const string NoDelFlag = "1";                                                                  //默认删除标记1表示未删除,0表示删除
                string       Save      = DataSources.GetDescription(DataSources.EnumOperateType.save, true);   //保存操作
                string       Submit    = DataSources.GetDescription(DataSources.EnumOperateType.submit, true); //提交操作
                //SQL语句拼装操作
                SysSQLString sysStringSql = new SysSQLString();
                sysStringSql.cmdType = CommandType.Text;
                Dictionary <string, string> dicParam = new Dictionary <string, string>();//保存SQL语句参数值
                CommonFuncCall.FillEntityByControls(this, stockShippingEntity);
                stockShippingEntity.stock_shipping_id = StockShippingId;

                stockShippingEntity.update_by   = GlobalStaticObj.UserID;
                stockShippingEntity.operators   = GlobalStaticObj.UserID;
                stockShippingEntity.enable_flag = NoDelFlag;
                if (HandleType == Save)
                {
                    stockShippingEntity.order_status      = Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
                    stockShippingEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
                }
                else if (HandleType == Submit)
                {
                    stockShippingEntity.order_status      = Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString();
                    stockShippingEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
                }
                if (stockShippingEntity != null)
                {
                    StringBuilder sb = new StringBuilder();
                    sb.Append(" Insert Into tb_parts_stock_shipping( ");
                    StringBuilder sb_PrValue = new StringBuilder();
                    StringBuilder sb_PrName  = new StringBuilder();
                    foreach (PropertyInfo info in stockShippingEntity.GetType().GetProperties())
                    {
                        string name  = info.Name;
                        object value = info.GetValue(stockShippingEntity, null);
                        sb_PrName.Append("," + name);   //数据表字段名
                        sb_PrValue.Append(",@" + name); //数据表字段值
                        dicParam.Add(name, value == null ? "" : value.ToString());
                    }
                    sb.Append(sb_PrName.ToString().Substring(1, sb_PrName.ToString().Length - 1) + ") Values ("); //追加字段名
                    sb.Append(sb_PrValue.ToString().Substring(1, sb_PrValue.ToString().Length - 1) + ");");       //追加字段值
                    //完成SQL语句的拼装
                    sysStringSql.sqlString = sb.ToString();
                    sysStringSql.Param     = dicParam;
                    listSql.Add(sysStringSql);
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }