/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_FileList_SignatureLog set ");
strSql.Append("FileListID=@FileListID,");
strSql.Append("SingleProjectID=@SingleProjectID,");
strSql.Append("Signature_DT=@Signature_DT,");
strSql.Append("Signature_UserID=@Signature_UserID,");
strSql.Append("Signature_UserRoleCode=@Signature_UserRoleCode,");
strSql.Append("FileListTmpID=@FileListTmpID,");
strSql.Append("Message=@Message,");
strSql.Append("OperationType=@OperationType,");
strSql.Append("SignatureFinishFlag=@SignatureFinishFlag,");
strSql.Append("SignatureFinish_DT=@SignatureFinish_DT ");
strSql.Append(" where SignatureLogID=@SignatureLogID ");
SqlParameter[] parameters =
{
new SqlParameter("@FileListID", SqlDbType.Int, 8),
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@Signature_DT", SqlDbType.DateTime),
new SqlParameter("@Signature_UserID", SqlDbType.Int, 8),
new SqlParameter("@Signature_UserRoleCode", SqlDbType.NVarChar, 50),
new SqlParameter("@FileListTmpID", SqlDbType.Int, 8),
new SqlParameter("@Message", SqlDbType.NVarChar, 500),
new SqlParameter("@OperationType", SqlDbType.NVarChar, 50),
new SqlParameter("@SignatureLogID", SqlDbType.Int, 8),
new SqlParameter("@SignatureFinishFlag", SqlDbType.NVarChar, 1),
new SqlParameter("@SignatureFinish_DT", SqlDbType.DateTime)
};
parameters[0].Value = model.FileListID;
parameters[1].Value = model.SingleProjectID;
parameters[2].Value = model.Signature_DT;
parameters[3].Value = model.Signature_UserID;
parameters[4].Value = model.Signature_UserRoleCode;
parameters[5].Value = model.FileListTmpID;
parameters[6].Value = model.Message;
parameters[7].Value = model.OperationType;
parameters[8].Value = model.SignatureLogID;
parameters[9].Value = model.SignatureFinishFlag;
parameters[10].Value = model.SignatureFinish_DT;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL DataRowToModel(DataRow row)
{
DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model = new DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL();
if (row != null)
{
if (row["SignatureLogID"] != null && row["SignatureLogID"].ToString() != "")
{
model.SignatureLogID = int.Parse(row["SignatureLogID"].ToString());
}
if (row["FileListID"] != null && row["FileListID"].ToString() != "")
{
model.FileListID = int.Parse(row["FileListID"].ToString());
}
if (row["SingleProjectID"] != null && row["SingleProjectID"].ToString() != "")
{
model.SingleProjectID = int.Parse(row["SingleProjectID"].ToString());
}
if (row["Signature_DT"] != null && row["Signature_DT"].ToString() != "")
{
model.Signature_DT = DateTime.Parse(row["Signature_DT"].ToString());
}
if (row["Signature_UserID"] != null && row["Signature_UserID"].ToString() != "")
{
model.Signature_UserID = int.Parse(row["Signature_UserID"].ToString());
}
if (row["Signature_UserRoleCode"] != null)
{
model.Signature_UserRoleCode = row["Signature_UserRoleCode"].ToString();
}
if (row["FileListTmpID"] != null && row["FileListTmpID"].ToString() != "")
{
model.FileListTmpID = int.Parse(row["FileListTmpID"].ToString());
}
if (row["Message"] != null)
{
model.Message = row["Message"].ToString();
}
if (row["OperationType"] != null)
{
model.OperationType = row["OperationType"].ToString();
}
if (row["SignatureFinishFlag"] != null)
{
model.SignatureFinishFlag = row["SignatureFinishFlag"].ToString();
}
if (row["SignatureFinish_DT"] != null && row["SignatureFinish_DT"].ToString() != "")
{
model.SignatureFinish_DT = DateTime.Parse(row["SignatureFinish_DT"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL GetModel(int SignatureLogID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SignatureLogID,FileListID,SingleProjectID,Signature_DT,Signature_UserID,Signature_UserRoleCode,FileListTmpID,Message,OperationType,SignatureFinishFlag,SignatureFinish_DT from T_FileList_SignatureLog ");
strSql.Append(" where SignatureLogID=@SignatureLogID ");
SqlParameter[] parameters =
{
new SqlParameter("@SignatureLogID", SqlDbType.Int, 8)
};
parameters[0].Value = SignatureLogID;
DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model = new DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
