/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.CallRecord_ORIG_Authorizer model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@IP", SqlDbType.VarChar, 15), new SqlParameter("@AuthorizeCode", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.RecID; parameters[1].Value = model.IP; parameters[2].Value = model.AuthorizeCode; parameters[3].Value = model.Remark; parameters[4].Value = model.CreateTime; parameters[5].Value = model.Status; return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_CALLRECORD_ORIG_AUTHORIZER_UPDATE, parameters)); }
private Entities.CallRecord_ORIG_Authorizer LoadSingleCallRecord_ORIG_Authorizer(DataRow row) { Entities.CallRecord_ORIG_Authorizer model = new Entities.CallRecord_ORIG_Authorizer(); if (row["RecID"].ToString() != "") { model.RecID = int.Parse(row["RecID"].ToString()); } model.IP = row["IP"].ToString(); model.AuthorizeCode = row["AuthorizeCode"].ToString(); model.Remark = row["Remark"].ToString(); if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.CallRecord_ORIG_Authorizer model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@IP", SqlDbType.VarChar, 15), new SqlParameter("@AuthorizeCode", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.IP; parameters[2].Value = model.AuthorizeCode; parameters[3].Value = model.Remark; parameters[4].Value = model.CreateTime; parameters[5].Value = model.Status; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_CALLRECORD_ORIG_AUTHORIZER_INSERT, parameters); return((int)parameters[0].Value); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.CallRecord_ORIG_Authorizer model) { return(Dal.CallRecord_ORIG_Authorizer.Instance.Update(sqltran, model)); }
//#region Insert ///// <summary> ///// 增加一条数据 ///// </summary> //public int Insert(Entities.CallRecord_ORIG_Authorizer model) //{ // return Dal.CallRecord_ORIG_Authorizer.Instance.Insert(model); //} ///// <summary> ///// 增加一条数据 ///// </summary> //public int Insert(SqlTransaction sqltran, Entities.CallRecord_ORIG_Authorizer model) //{ // return Dal.CallRecord_ORIG_Authorizer.Instance.Insert(sqltran, model); //} //#endregion #region Update /// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.CallRecord_ORIG_Authorizer model) { return(Dal.CallRecord_ORIG_Authorizer.Instance.Update(model)); }