/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.tTopic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tTopic(");
strSql.Append("topicTitle,topicTime,topicFile,policyTime,policyAdress,policyPeople,policyProcess,policyResult,policyDone,policyFile,policyDptName,policyDptId,isCheck,policyType,isCheckPeo,isCheckTime,savePeo,savePeoId)");
strSql.Append(" values (");
strSql.Append("@topicTitle,@topicTime,@topicFile,@policyTime,@policyAdress,@policyPeople,@policyProcess,@policyResult,@policyDone,@policyFile,@policyDptName,@policyDptId,@isCheck,@policyType,@isCheckPeo,@isCheckTime,@savePeo,@savePeoId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@topicTitle", SqlDbType.NVarChar, 150),
new SqlParameter("@topicTime", SqlDbType.DateTime),
new SqlParameter("@topicFile", SqlDbType.NVarChar, -1),
new SqlParameter("@policyTime", SqlDbType.DateTime),
new SqlParameter("@policyAdress", SqlDbType.NVarChar, 150),
new SqlParameter("@policyPeople", SqlDbType.NVarChar, 550),
new SqlParameter("@policyProcess", SqlDbType.NVarChar, -1),
new SqlParameter("@policyResult", SqlDbType.NVarChar, -1),
new SqlParameter("@policyDone", SqlDbType.NVarChar, -1),
new SqlParameter("@policyFile", SqlDbType.NVarChar, -1),
new SqlParameter("@policyDptName", SqlDbType.NVarChar, 150),
new SqlParameter("@policyDptId", SqlDbType.Int, 4),
new SqlParameter("@isCheck", SqlDbType.VarChar, 20),
new SqlParameter("@policyType", SqlDbType.Int, 4),
new SqlParameter("@isCheckPeo", SqlDbType.NVarChar, 50),
new SqlParameter("@isCheckTime", SqlDbType.DateTime),
new SqlParameter("@savePeo", SqlDbType.NVarChar, 50),
new SqlParameter("@savePeoId", SqlDbType.Int, 4)
};
parameters[0].Value = model.topicTitle;
parameters[1].Value = model.topicTime;
parameters[2].Value = model.topicFile;
parameters[3].Value = model.policyTime;
parameters[4].Value = model.policyAdress;
parameters[5].Value = model.policyPeople;
parameters[6].Value = model.policyProcess;
parameters[7].Value = model.policyResult;
parameters[8].Value = model.policyDone;
parameters[9].Value = model.policyFile;
parameters[10].Value = model.policyDptName;
parameters[11].Value = model.policyDptId;
parameters[12].Value = model.isCheck;
parameters[13].Value = model.policyType;
parameters[14].Value = model.isCheckPeo;
parameters[15].Value = model.isCheckTime;
parameters[16].Value = model.savePeo;
parameters[17].Value = model.savePeoId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tTopic GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,topicTitle,topicTime,topicFile,policyTime,policyAdress,policyPeople,policyProcess,policyResult,policyDone,policyFile,policyDptName,policyDptId,isCheck,policyType,isCheckPeo,isCheckTime,savePeo,savePeoId from tTopic ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Maticsoft.Model.tTopic model = new Maticsoft.Model.tTopic();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tTopic DataRowToModel(DataRow row)
{
Maticsoft.Model.tTopic model = new Maticsoft.Model.tTopic();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["topicTitle"] != null)
{
model.topicTitle = row["topicTitle"].ToString();
}
if (row["topicTime"] != null && row["topicTime"].ToString() != "")
{
model.topicTime = DateTime.Parse(row["topicTime"].ToString());
}
if (row["topicFile"] != null)
{
model.topicFile = row["topicFile"].ToString();
}
if (row["policyTime"] != null && row["policyTime"].ToString() != "")
{
model.policyTime = DateTime.Parse(row["policyTime"].ToString());
}
if (row["policyAdress"] != null)
{
model.policyAdress = row["policyAdress"].ToString();
}
if (row["policyPeople"] != null)
{
model.policyPeople = row["policyPeople"].ToString();
}
if (row["policyProcess"] != null)
{
model.policyProcess = row["policyProcess"].ToString();
}
if (row["policyResult"] != null)
{
model.policyResult = row["policyResult"].ToString();
}
if (row["policyDone"] != null)
{
model.policyDone = row["policyDone"].ToString();
}
if (row["policyFile"] != null)
{
model.policyFile = row["policyFile"].ToString();
}
if (row["policyDptName"] != null)
{
model.policyDptName = row["policyDptName"].ToString();
}
if (row["policyDptId"] != null && row["policyDptId"].ToString() != "")
{
model.policyDptId = int.Parse(row["policyDptId"].ToString());
}
if (row["isCheck"] != null)
{
model.isCheck = row["isCheck"].ToString();
}
if (row["policyType"] != null && row["policyType"].ToString() != "")
{
model.policyType = int.Parse(row["policyType"].ToString());
}
if (row["isCheckPeo"] != null)
{
model.isCheckPeo = row["isCheckPeo"].ToString();
}
if (row["isCheckTime"] != null && row["isCheckTime"].ToString() != "")
{
model.isCheckTime = DateTime.Parse(row["isCheckTime"].ToString());
}
if (row["savePeo"] != null)
{
model.savePeo = row["savePeo"].ToString();
}
if (row["savePeoId"] != null && row["savePeoId"].ToString() != "")
{
model.savePeoId = int.Parse(row["savePeoId"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.tTopic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tTopic set ");
strSql.Append("topicTitle=@topicTitle,");
strSql.Append("topicTime=@topicTime,");
strSql.Append("topicFile=@topicFile,");
strSql.Append("policyTime=@policyTime,");
strSql.Append("policyAdress=@policyAdress,");
strSql.Append("policyPeople=@policyPeople,");
strSql.Append("policyProcess=@policyProcess,");
strSql.Append("policyResult=@policyResult,");
strSql.Append("policyDone=@policyDone,");
strSql.Append("policyFile=@policyFile,");
strSql.Append("policyDptName=@policyDptName,");
strSql.Append("policyDptId=@policyDptId,");
strSql.Append("isCheck=@isCheck,");
strSql.Append("policyType=@policyType,");
strSql.Append("isCheckPeo=@isCheckPeo,");
strSql.Append("isCheckTime=@isCheckTime,");
strSql.Append("savePeo=@savePeo,");
strSql.Append("savePeoId=@savePeoId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@topicTitle", SqlDbType.NVarChar, 150),
new SqlParameter("@topicTime", SqlDbType.DateTime),
new SqlParameter("@topicFile", SqlDbType.NVarChar, -1),
new SqlParameter("@policyTime", SqlDbType.DateTime),
new SqlParameter("@policyAdress", SqlDbType.NVarChar, 150),
new SqlParameter("@policyPeople", SqlDbType.NVarChar, 550),
new SqlParameter("@policyProcess", SqlDbType.NVarChar, -1),
new SqlParameter("@policyResult", SqlDbType.NVarChar, -1),
new SqlParameter("@policyDone", SqlDbType.NVarChar, -1),
new SqlParameter("@policyFile", SqlDbType.NVarChar, -1),
new SqlParameter("@policyDptName", SqlDbType.NVarChar, 150),
new SqlParameter("@policyDptId", SqlDbType.Int, 4),
new SqlParameter("@isCheck", SqlDbType.VarChar, 20),
new SqlParameter("@policyType", SqlDbType.Int, 4),
new SqlParameter("@isCheckPeo", SqlDbType.NVarChar, 50),
new SqlParameter("@isCheckTime", SqlDbType.DateTime),
new SqlParameter("@savePeo", SqlDbType.NVarChar, 50),
new SqlParameter("@savePeoId", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.topicTitle;
parameters[1].Value = model.topicTime;
parameters[2].Value = model.topicFile;
parameters[3].Value = model.policyTime;
parameters[4].Value = model.policyAdress;
parameters[5].Value = model.policyPeople;
parameters[6].Value = model.policyProcess;
parameters[7].Value = model.policyResult;
parameters[8].Value = model.policyDone;
parameters[9].Value = model.policyFile;
parameters[10].Value = model.policyDptName;
parameters[11].Value = model.policyDptId;
parameters[12].Value = model.isCheck;
parameters[13].Value = model.policyType;
parameters[14].Value = model.isCheckPeo;
parameters[15].Value = model.isCheckTime;
parameters[16].Value = model.savePeo;
parameters[17].Value = model.savePeoId;
parameters[18].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
