/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.T_WorkFlowDefine_MDL GetModel(int WorkFlowDefineID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WorkFlowDefineID,SingleProjectID,WorkFlowID,WorkFlowName,Description,OrderIndex,Del,PID,RoleID,UserID,CreateDate,");
strSql.Append("DoStatus,IsRollBack,UseForSuperAdmin,UseForArchive,UseForCompanyLeader,UseForCompany,UseForAll,SubmitStatus,SubmitUserID,");
strSql.Append("SubmitDateTime,SubmitCellPath,RecvUserID,RecvDateTime,RecvCellPath,CompanyID,DescriptionToArchive,DescriptionToCompany,RollBackCount ");
strSql.Append("from T_WorkFlowDefine ");
strSql.Append(" where WorkFlowDefineID=@WorkFlowDefineID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkFlowDefineID", SqlDbType.Int, 8)
};
parameters[0].Value = WorkFlowDefineID;
DigiPower.Onlinecol.Standard.Model.T_WorkFlowDefine_MDL model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlowDefine_MDL();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["WorkFlowDefineID"].ToString() != "")
{
model.WorkFlowDefineID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowDefineID"].ToString());
}
if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "")
{
model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString());
}
if (ds.Tables[0].Rows[0]["WorkFlowID"].ToString() != "")
{
model.WorkFlowID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowID"].ToString());
}
model.WorkFlowName = ds.Tables[0].Rows[0]["WorkFlowName"].ToString();
model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
if (ds.Tables[0].Rows[0]["OrderIndex"].ToString() != "")
{
model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString());
}
if (ds.Tables[0].Rows[0]["Del"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Del"].ToString() == "1") || (ds.Tables[0].Rows[0]["Del"].ToString().ToLower() == "true"))
{
model.Del = true;
}
else
{
model.Del = false;
}
}
model.PID = ds.Tables[0].Rows[0]["PID"].ToString();
if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["DoStatus"].ToString() != "")
{
model.DoStatus = int.Parse(ds.Tables[0].Rows[0]["DoStatus"].ToString());
}
if (ds.Tables[0].Rows[0]["IsRollBack"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsRollBack"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsRollBack"].ToString().ToLower() == "true"))
{
model.IsRollBack = true;
}
else
{
model.IsRollBack = false;
}
}
if (ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString().ToLower() == "true"))
{
model.UseForSuperAdmin = true;
}
else
{
model.UseForSuperAdmin = false;
}
}
if (ds.Tables[0].Rows[0]["UseForArchive"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["UseForArchive"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForArchive"].ToString().ToLower() == "true"))
{
model.UseForArchive = true;
}
else
{
model.UseForArchive = false;
}
}
if (ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString().ToLower() == "true"))
{
model.UseForCompanyLeader = true;
}
else
{
model.UseForCompanyLeader = false;
}
}
if (ds.Tables[0].Rows[0]["UseForCompany"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["UseForCompany"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForCompany"].ToString().ToLower() == "true"))
{
model.UseForCompany = true;
}
else
{
model.UseForCompany = false;
}
}
if (ds.Tables[0].Rows[0]["UseForAll"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["UseForAll"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForAll"].ToString().ToLower() == "true"))
{
model.UseForAll = true;
}
else
{
model.UseForAll = false;
}
}
if (ds.Tables[0].Rows[0]["SubmitStatus"].ToString() != "")
{
model.SubmitStatus = int.Parse(ds.Tables[0].Rows[0]["SubmitStatus"].ToString());
}
if (ds.Tables[0].Rows[0]["SubmitUserID"].ToString() != "")
{
model.SubmitUserID = int.Parse(ds.Tables[0].Rows[0]["SubmitUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["SubmitDateTime"].ToString() != "")
{
model.SubmitDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubmitDateTime"].ToString());
}
model.SubmitCellPath = ds.Tables[0].Rows[0]["SubmitCellPath"].ToString();
if (ds.Tables[0].Rows[0]["RecvUserID"].ToString() != "")
{
model.RecvUserID = int.Parse(ds.Tables[0].Rows[0]["RecvUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RecvDateTime"].ToString() != "")
{
model.RecvDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecvDateTime"].ToString());
}
model.RecvCellPath = ds.Tables[0].Rows[0]["RecvCellPath"].ToString();
if (ds.Tables[0].Rows[0]["CompanyID"].ToString() != "")
{
model.CompanyID = int.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString());
}
model.DescriptionToArchive = ds.Tables[0].Rows[0]["DescriptionToArchive"].ToString();
model.DescriptionToCompany = ds.Tables[0].Rows[0]["DescriptionToCompany"].ToString();
if (ds.Tables[0].Rows[0]["RollBackCount"].ToString() != "")
{
model.RollBackCount = int.Parse(ds.Tables[0].Rows[0]["RollBackCount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DigiPower.Onlinecol.Standard.Model.T_WorkFlowDefine_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_WorkFlowDefine(");
strSql.Append("SingleProjectID,WorkFlowID,WorkFlowName,Description,OrderIndex,Del,PID,RoleID,UserID,CreateDate,DoStatus,IsRollBack,UseForSuperAdmin,");
strSql.Append("UseForArchive,UseForCompanyLeader,UseForCompany,UseForAll,SubmitStatus,SubmitUserID,SubmitDateTime,SubmitCellPath,RecvUserID,RecvDateTime,");
strSql.Append("RecvCellPath,CompanyID,DescriptionToArchive,DescriptionToCompany,RollBackCount)");
strSql.Append(" values (");
strSql.Append("@SingleProjectID,@WorkFlowID,@WorkFlowName,@Description,@OrderIndex,@Del,@PID,@RoleID,@UserID,@CreateDate,@DoStatus,@IsRollBack,@UseForSuperAdmin,");
strSql.Append("@UseForArchive,@UseForCompanyLeader,@UseForCompany,@UseForAll,@SubmitStatus,@SubmitUserID,@SubmitDateTime,@SubmitCellPath,@RecvUserID,");
strSql.Append("@RecvDateTime,@RecvCellPath,@CompanyID,@DescriptionToArchive,@DescriptionToCompany,@RollBackCount)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@WorkFlowID", SqlDbType.Int, 8),
new SqlParameter("@WorkFlowName", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderIndex", SqlDbType.Int, 8),
new SqlParameter("@Del", SqlDbType.Bit, 1),
new SqlParameter("@PID", SqlDbType.NVarChar, 20),
new SqlParameter("@RoleID", SqlDbType.Int, 8),
new SqlParameter("@UserID", SqlDbType.Int, 8),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@DoStatus", SqlDbType.Int, 8),
new SqlParameter("@IsRollBack", SqlDbType.Bit, 1),
new SqlParameter("@UseForSuperAdmin", SqlDbType.Bit, 1),
new SqlParameter("@UseForArchive", SqlDbType.Bit, 1),
new SqlParameter("@UseForCompanyLeader", SqlDbType.Bit, 1),
new SqlParameter("@UseForCompany", SqlDbType.Bit, 1),
new SqlParameter("@UseForAll", SqlDbType.Bit, 1),
new SqlParameter("@SubmitStatus", SqlDbType.Int, 8),
new SqlParameter("@SubmitUserID", SqlDbType.Int, 8),
new SqlParameter("@SubmitDateTime", SqlDbType.DateTime),
new SqlParameter("@SubmitCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@RecvUserID", SqlDbType.Int, 8),
new SqlParameter("@RecvDateTime", SqlDbType.DateTime),
new SqlParameter("@RecvCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@CompanyID", SqlDbType.Int, 8),
new SqlParameter("@DescriptionToArchive", SqlDbType.NVarChar, 400),
new SqlParameter("@DescriptionToCompany", SqlDbType.NVarChar, 400),
new SqlParameter("@RollBackCount", SqlDbType.Int, 8)
};
parameters[0].Value = model.SingleProjectID;
parameters[1].Value = model.WorkFlowID;
parameters[2].Value = model.WorkFlowName;
parameters[3].Value = model.Description;
parameters[4].Value = model.OrderIndex;
parameters[5].Value = model.Del;
parameters[6].Value = model.PID;
parameters[7].Value = model.RoleID;
parameters[8].Value = model.UserID;
parameters[9].Value = model.CreateDate;
parameters[10].Value = model.DoStatus;
parameters[11].Value = model.IsRollBack;
parameters[12].Value = model.UseForSuperAdmin;
parameters[13].Value = model.UseForArchive;
parameters[14].Value = model.UseForCompanyLeader;
parameters[15].Value = model.UseForCompany;
parameters[16].Value = model.UseForAll;
parameters[17].Value = model.SubmitStatus;
parameters[18].Value = model.SubmitUserID;
parameters[19].Value = model.SubmitDateTime;
parameters[20].Value = model.SubmitCellPath;
parameters[21].Value = model.RecvUserID;
parameters[22].Value = model.RecvDateTime;
parameters[23].Value = model.RecvCellPath;
parameters[24].Value = model.CompanyID;
parameters[25].Value = model.DescriptionToArchive;
parameters[26].Value = model.DescriptionToCompany;
parameters[27].Value = model.RollBackCount;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.T_WorkFlowDefine_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_WorkFlowDefine set ");
strSql.Append("SingleProjectID=@SingleProjectID,");
strSql.Append("WorkFlowID=@WorkFlowID,");
strSql.Append("WorkFlowName=@WorkFlowName,");
strSql.Append("Description=@Description,");
strSql.Append("OrderIndex=@OrderIndex,");
strSql.Append("Del=@Del,");
strSql.Append("PID=@PID,");
strSql.Append("RoleID=@RoleID,");
strSql.Append("UserID=@UserID,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("DoStatus=@DoStatus,");
strSql.Append("IsRollBack=@IsRollBack,");
strSql.Append("UseForSuperAdmin=@UseForSuperAdmin,");
strSql.Append("UseForArchive=@UseForArchive,");
strSql.Append("UseForCompanyLeader=@UseForCompanyLeader,");
strSql.Append("UseForCompany=@UseForCompany,");
strSql.Append("UseForAll=@UseForAll,");
strSql.Append("SubmitStatus=@SubmitStatus,");
strSql.Append("SubmitUserID=@SubmitUserID,");
strSql.Append("SubmitDateTime=@SubmitDateTime,");
strSql.Append("SubmitCellPath=@SubmitCellPath,");
strSql.Append("RecvUserID=@RecvUserID,");
strSql.Append("RecvDateTime=@RecvDateTime,");
strSql.Append("RecvCellPath=@RecvCellPath,");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("DescriptionToArchive=@DescriptionToArchive,");
strSql.Append("DescriptionToCompany=@DescriptionToCompany,");
strSql.Append("RollBackCount=@RollBackCount");
strSql.Append(" where WorkFlowDefineID=@WorkFlowDefineID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkFlowDefineID", SqlDbType.Int, 8),
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@WorkFlowID", SqlDbType.Int, 8),
new SqlParameter("@WorkFlowName", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderIndex", SqlDbType.Int, 8),
new SqlParameter("@Del", SqlDbType.Bit, 1),
new SqlParameter("@PID", SqlDbType.NVarChar, 20),
new SqlParameter("@RoleID", SqlDbType.Int, 8),
new SqlParameter("@UserID", SqlDbType.Int, 8),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@DoStatus", SqlDbType.Int, 8),
new SqlParameter("@IsRollBack", SqlDbType.Bit, 1),
new SqlParameter("@UseForSuperAdmin", SqlDbType.Bit, 1),
new SqlParameter("@UseForArchive", SqlDbType.Bit, 1),
new SqlParameter("@UseForCompanyLeader", SqlDbType.Bit, 1),
new SqlParameter("@UseForCompany", SqlDbType.Bit, 1),
new SqlParameter("@UseForAll", SqlDbType.Bit, 1),
new SqlParameter("@SubmitStatus", SqlDbType.Int, 8),
new SqlParameter("@SubmitUserID", SqlDbType.Int, 8),
new SqlParameter("@SubmitDateTime", SqlDbType.DateTime),
new SqlParameter("@SubmitCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@RecvUserID", SqlDbType.Int, 8),
new SqlParameter("@RecvDateTime", SqlDbType.DateTime),
new SqlParameter("@RecvCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@CompanyID", SqlDbType.Int, 8),
new SqlParameter("@DescriptionToArchive", SqlDbType.NVarChar, 400),
new SqlParameter("@DescriptionToCompany", SqlDbType.NVarChar, 400),
new SqlParameter("@RollBackCount", SqlDbType.Int, 8)
};
parameters[0].Value = model.WorkFlowDefineID;
parameters[1].Value = model.SingleProjectID;
parameters[2].Value = model.WorkFlowID;
parameters[3].Value = model.WorkFlowName;
parameters[4].Value = model.Description;
parameters[5].Value = model.OrderIndex;
parameters[6].Value = model.Del;
parameters[7].Value = model.PID;
parameters[8].Value = model.RoleID;
parameters[9].Value = model.UserID;
parameters[10].Value = model.CreateDate;
parameters[11].Value = model.DoStatus;
parameters[12].Value = model.IsRollBack;
parameters[13].Value = model.UseForSuperAdmin;
parameters[14].Value = model.UseForArchive;
parameters[15].Value = model.UseForCompanyLeader;
parameters[16].Value = model.UseForCompany;
parameters[17].Value = model.UseForAll;
parameters[18].Value = model.SubmitStatus;
parameters[19].Value = model.SubmitUserID;
parameters[20].Value = model.SubmitDateTime;
parameters[21].Value = model.SubmitCellPath;
parameters[22].Value = model.RecvUserID;
parameters[23].Value = model.RecvDateTime;
parameters[24].Value = model.RecvCellPath;
parameters[25].Value = model.CompanyID;
parameters[26].Value = model.DescriptionToArchive;
parameters[27].Value = model.DescriptionToCompany;
parameters[28].Value = model.RollBackCount;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
