public bool Update(PEIS.Model.NatLog model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update NatLog set "); stringBuilder.Append("Operater=@Operater,"); stringBuilder.Append("OperateDate=@OperateDate,"); stringBuilder.Append("OperateIP=@OperateIP,"); stringBuilder.Append("OperateType=@OperateType,"); stringBuilder.Append("OperateContent=@OperateContent"); stringBuilder.Append(" where ID_Log=@ID_Log"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@Operater", SqlDbType.NVarChar, 10), new SqlParameter("@OperateDate", SqlDbType.DateTime), new SqlParameter("@OperateIP", SqlDbType.VarChar, 128), new SqlParameter("@OperateType", SqlDbType.Int, 4), new SqlParameter("@OperateContent", SqlDbType.NVarChar, 128), new SqlParameter("@ID_Log", SqlDbType.Int, 4) }; array[0].Value = model.Operater; array[1].Value = model.OperateDate; array[2].Value = model.OperateIP; array[3].Value = model.OperateType; array[4].Value = model.OperateContent; array[5].Value = model.ID_Log; int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array); return(num > 0); }
public int Add(PEIS.Model.NatLog model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into NatLog("); stringBuilder.Append("Operater,OperateDate,OperateIP,OperateType,OperateContent)"); stringBuilder.Append(" values ("); stringBuilder.Append("@Operater,@OperateDate,@OperateIP,@OperateType,@OperateContent)"); stringBuilder.Append(";select @@IDENTITY"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@Operater", SqlDbType.NVarChar, 10), new SqlParameter("@OperateDate", SqlDbType.DateTime), new SqlParameter("@OperateIP", SqlDbType.VarChar, 128), new SqlParameter("@OperateType", SqlDbType.Int, 4), new SqlParameter("@OperateContent", SqlDbType.NVarChar, 128) }; array[0].Value = model.Operater; array[1].Value = model.OperateDate; array[2].Value = model.OperateIP; array[3].Value = model.OperateType; array[4].Value = model.OperateContent; object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array); int result; if (single == null) { result = 0; } else { result = Convert.ToInt32(single); } return(result); }
public List <PEIS.Model.NatLog> DataTableToList(DataTable dt) { List <PEIS.Model.NatLog> list = new List <PEIS.Model.NatLog>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.NatLog natLog = new PEIS.Model.NatLog(); if (dt.Rows[i]["ID_Log"].ToString() != "") { natLog.ID_Log = int.Parse(dt.Rows[i]["ID_Log"].ToString()); } natLog.Operater = dt.Rows[i]["Operater"].ToString(); if (dt.Rows[i]["OperateDate"].ToString() != "") { natLog.OperateDate = DateTime.Parse(dt.Rows[i]["OperateDate"].ToString()); } natLog.OperateIP = dt.Rows[i]["OperateIP"].ToString(); if (dt.Rows[i]["OperateType"].ToString() != "") { natLog.OperateType = int.Parse(dt.Rows[i]["OperateType"].ToString()); } natLog.OperateContent = dt.Rows[i]["OperateContent"].ToString(); list.Add(natLog); } } return(list); }
public PEIS.Model.NatLog GetModel(int ID_Log) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 ID_Log,Operater,OperateDate,OperateIP,OperateType,OperateContent from NatLog "); stringBuilder.Append(" where ID_Log=@ID_Log"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_Log", SqlDbType.Int, 4) }; array[0].Value = ID_Log; PEIS.Model.NatLog natLog = new PEIS.Model.NatLog(); DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array); PEIS.Model.NatLog result; if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows[0]["ID_Log"].ToString() != "") { natLog.ID_Log = int.Parse(dataSet.Tables[0].Rows[0]["ID_Log"].ToString()); } natLog.Operater = dataSet.Tables[0].Rows[0]["Operater"].ToString(); if (dataSet.Tables[0].Rows[0]["OperateDate"].ToString() != "") { natLog.OperateDate = DateTime.Parse(dataSet.Tables[0].Rows[0]["OperateDate"].ToString()); } natLog.OperateIP = dataSet.Tables[0].Rows[0]["OperateIP"].ToString(); if (dataSet.Tables[0].Rows[0]["OperateType"].ToString() != "") { natLog.OperateType = int.Parse(dataSet.Tables[0].Rows[0]["OperateType"].ToString()); } natLog.OperateContent = dataSet.Tables[0].Rows[0]["OperateContent"].ToString(); result = natLog; } else { result = null; } return(result); }
public bool Update(PEIS.Model.NatLog model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.NatLog model) { return(this.dal.Add(model)); }