| | |
| | | return true; |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 修改完结 |
| | | /// </summary> |
| | | /// <param name="model"></param> |
| | | /// <returns></returns> |
| | | public bool UpdateWanjie(Infrastructure.Domain.IAggregateRoot model) |
| | | { |
| | | Model.OA_CorporateClients trueModel = model as Model.OA_CorporateClients; |
| | | if (trueModel == null) |
| | | { |
| | | return false; |
| | | } |
| | | |
| | | SqlParameter par = null; |
| | | if (trueModel.LastOrderTime.HasValue) |
| | | { |
| | | par = new SqlParameter("@LastOrderTime", trueModel.LastOrderTime.Value); |
| | | } |
| | | else |
| | | { |
| | | par = new SqlParameter("@LastOrderTime", DBNull.Value); |
| | | } |
| | | SqlParameter par1 = null; |
| | | if (trueModel.WanjieTime.HasValue) |
| | | { |
| | | par1 = new SqlParameter("@WanjieTime", trueModel.WanjieTime.Value); |
| | | } |
| | | else |
| | | { |
| | | par1 = new SqlParameter("@WanjieTime", DBNull.Value); |
| | | } |
| | | |
| | | IList<SqlParameter> sqlParms = new List<SqlParameter>() |
| | | { |
| | | new SqlParameter("@Keyid",trueModel.Keyid), |
| | | |
| | | par, |
| | | |
| | | par1, |
| | | |
| | | new SqlParameter("@Shifouwanjie",trueModel.Shifouwanjie??0) , |
| | | }; |
| | | string sql = "Update [OA_CorporateClients] Set [Shifouwanjie]=@Shifouwanjie,[WanjieTime]=@WanjieTime,[LastOrderTime]=@LastOrderTime where [Keyid] =@Keyid "; |
| | | |
| | | try |
| | | { |
| | | _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 转移客户 |
| | | /// </summary> |