| | |
| | | new SqlParameter("@createtime",trueModel.createtime), |
| | | new SqlParameter("@modifier",trueModel.modifier), |
| | | new SqlParameter("@modifytime",trueModel.modifytime), |
| | | new SqlParameter("@Jusequanxian",string.IsNullOrEmpty(trueModel.Jusequanxian)?"":trueModel.Jusequanxian), |
| | | |
| | | }; |
| | | string sql = "Insert Into Adm_zhanghaomima ([FirmId],[type_id],[chanpinxiangmu],[zhanghao], [mima], [mibao],[rec_status], [creater],[createtime], [modifier],[modifytime])" |
| | | + " Values (@FirmId,@type_id,@chanpinxiangmu, @zhanghao, @mima, @mibao, @rec_status, @creater, @createtime, @modifier,@modifytime)"; |
| | | string sql = "Insert Into Adm_zhanghaomima ([FirmId],[type_id],[chanpinxiangmu],[zhanghao], [mima], [mibao],[rec_status], [creater],[createtime], [modifier],[modifytime],[Jusequanxian])" |
| | | + " Values (@FirmId,@type_id,@chanpinxiangmu, @zhanghao, @mima, @mibao, @rec_status, @creater, @createtime, @modifier,@modifytime,@Jusequanxian)"; |
| | | try |
| | | { |
| | | _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据编号获得信息 |
| | | /// </summary> |
| | | /// <param name="Keyid">编号</param> |
| | | /// <returns></returns> |
| | | public IEnumerable<Adm_zhanghaomima> GetModelByKeyids(string keyids) |
| | | { |
| | | try |
| | | { |
| | | string condition = " "; |
| | | if (!string.IsNullOrEmpty(keyids)) |
| | | { |
| | | condition = " Keyid in (" + keyids + ")"; |
| | | } |
| | | else |
| | | { |
| | | return null; |
| | | } |
| | | |
| | | // return null;//错误数据返会空 |
| | | |
| | | return _dataBase.SelectModel<Adm_zhanghaomima>("*", "Adm_zhanghaomima", condition) as IList<Adm_zhanghaomima>;//执行查询 |
| | | |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 全部查询 |
| | | /// </summary> |