/// <summary> /// 车单状态接口 /// </summary> /// <param name="userID">车单编号(不能为空)</param> /// <param name="status">状态(=0 无效,=1 有效)</param> /// <param name="activationDate">生效日期(为空时不修改,格式yyyy-MM-dd)</param> /// <returns>=0 成功,=其他 错误代码</returns> public int SheetStatus(string userID, byte status, string activationDate) { try { if ((status != 0 && status != 1) || string.IsNullOrEmpty(userID)) { return((int)InterfaceReturnCode.ParameterError); } //卡片状态 = 1 Enabled 已发行, = 3 Disabled 禁用, byte cardStatus = (byte)(status == 0 ? 3 : 1); SQLHelperProvider sqlHelper = new SQLHelperProvider(AppConifg.Current.ParkingConnection); string cmdstr; if (!string.IsNullOrEmpty(activationDate)) { cmdstr = @"update Card set Status=@status,ActivationDate=@activationDate where CardID=@cardID"; } else { cmdstr = @"update Card set Status=@status where CardID=@cardID"; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = cmdstr; cmd.Parameters.AddWithValue("@status", cardStatus); if (!string.IsNullOrEmpty(activationDate)) { cmd.Parameters.AddWithValue("@activationDate", activationDate); } cmd.Parameters.AddWithValue("@cardID", userID); SQLQueryResult <int> result = sqlHelper.SQLExecuteNonQuery(cmd); InterfaceReturnCode code = CreateInterfaceReturnCode(result.Result); if (code == InterfaceReturnCode.Success && result.QueryObject == 0) { //返回更新行数为0时,标识为无记录 code = InterfaceReturnCode.DatabaseNoRecord; } return((int)code); } catch (Exception) { return((int)InterfaceReturnCode.InterfaceException);//接口执行期间发生错误 } }
/// <summary> /// 通过员工编号删除员工记录接口 /// </summary> /// <param name="employeeNum"></param> /// <returns></returns> public int DeleteEmployee(string employeeNum) { try { if (string.IsNullOrEmpty(employeeNum)) { return((int)InterfaceReturnCode.ParameterError); } SQLHelperProvider sqlHelper = new SQLHelperProvider(AppConifg.Current.ParkingConnection); string cmdstr = @"delete from Card where CardID=@cardID"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = cmdstr; cmd.Parameters.AddWithValue("@cardID", employeeNum); SQLResultCode code = sqlHelper.SQLExecuteNonQuery(cmd).Result; InterfaceReturnCode result = CreateInterfaceReturnCode(code); return((int)result); } catch (Exception) { return((int)InterfaceReturnCode.InterfaceException);//接口执行期间发生错误 } }