| | |
| | | new SqlParameter("@PSF_Beishu",trueModel.PSF_Beishu), |
| | | new SqlParameter("@PSF_Jichang",trueModel.PSF_Jichang), |
| | | new SqlParameter("@PSF_Yaoqiu",trueModel.PSF_Yaoqiu), |
| | | |
| | | new SqlParameter("@PSF_JichangId",trueModel.PSF_JichangId.HasValue?trueModel.PSF_JichangId.Value:0), |
| | | |
| | | }; |
| | | string sql = "Insert Into EC_MergerHoudaos ([MergerOrderId],[PSF_Houdaogongxu],[PSF_Shuliang],[PSF_Beishu], [PSF_Jichang], [PSF_Yaoqiu])" |
| | | + " Values (@MergerOrderId,@PSF_Houdaogongxu,@PSF_Shuliang, @PSF_Beishu, @PSF_Jichang, @PSF_Yaoqiu )"; |
| | | string sql = "Insert Into EC_MergerHoudaos ([MergerOrderId],[PSF_Houdaogongxu],[PSF_Shuliang],[PSF_Beishu], [PSF_Jichang], [PSF_Yaoqiu],[PSF_JichangId])" |
| | | + " Values (@MergerOrderId,@PSF_Houdaogongxu,@PSF_Shuliang, @PSF_Beishu, @PSF_Jichang, @PSF_Yaoqiu,@PSF_JichangId )"; |
| | | |
| | | try |
| | | { |
| | |
| | | new SqlParameter("@PSF_Beishu",trueModel.PSF_Beishu), |
| | | new SqlParameter("@PSF_Jichang",trueModel.PSF_Jichang), |
| | | new SqlParameter("@PSF_Yaoqiu",trueModel.PSF_Yaoqiu), |
| | | new SqlParameter("@PSF_JichangId",trueModel.PSF_JichangId.HasValue?trueModel.PSF_JichangId.Value:0), |
| | | }; |
| | | string sql = "Update EC_MergerHoudaos Set [MergerOrderId]=@MergerOrderId,[PSF_Houdaogongxu]=@PSF_Houdaogongxu,[PSF_Shuliang]=@PSF_Shuliang,[PSF_Beishu]=@PSF_Beishu, [PSF_Jichang]=@PSF_Jichang, [PSF_Yaoqiu]=@PSF_Yaoqiu where [Keyid] =@Keyid "; |
| | | string sql = "Update EC_MergerHoudaos Set [MergerOrderId]=@MergerOrderId,[PSF_Houdaogongxu]=@PSF_Houdaogongxu,[PSF_Shuliang]=@PSF_Shuliang,[PSF_Beishu]=@PSF_Beishu, [PSF_Jichang]=@PSF_Jichang, [PSF_Yaoqiu]=@PSF_Yaoqiu,[PSF_JichangId]=@PSF_JichangId where [Keyid] =@Keyid "; |
| | | |
| | | try |
| | | { |