| | |
| | | |
| | | new SqlParameter("@CuishouTime",trueModel.CuishouTime), |
| | | new SqlParameter("@Creater",trueModel.Creater), |
| | | |
| | | new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang), |
| | | |
| | | }; |
| | | string sql = "Insert Into OA_Kaipiaonewcuishou ( [KaipiaoId] , [Creater],[CreateTime],[CuishouTime] )" |
| | | + " Values ( @KaipiaoId, @Creater,@CreateTime,@CuishouTime )"; |
| | | string sql = "Insert Into OA_Kaipiaonewcuishou ( [KaipiaoId] , [Creater],[CreateTime],[CuishouTime],[Cuikuanqingkuang] )" |
| | | + " Values ( @KaipiaoId, @Creater,@CreateTime,@CuishouTime,@Cuikuanqingkuang )"; |
| | | try |
| | | { |
| | | _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); |
| | |
| | | |
| | | new SqlParameter("@CuishouTime",trueModel.CuishouTime), |
| | | new SqlParameter("@Creater",trueModel.Creater), |
| | | |
| | | new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang), |
| | | }; |
| | | string sql = "Update OA_Kaipiaonewcuishou Set [Creater]=@Creater,[CreateTime]=@CreateTime,[CuishouTime]=@CuishouTime where [Keyid] =@Keyid "; |
| | | string sql = "Update OA_Kaipiaonewcuishou Set [Creater]=@Creater,[CreateTime]=@CreateTime,[CuishouTime]=@CuishouTime,[Cuikuanqingkuang]=@Cuikuanqingkuang where [Keyid] =@Keyid "; |
| | | |
| | | try |
| | | { |