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));
}
