/// <summary>
/// 得到一个对象实体
/// </summary>
public tabExperienceProjectModel GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from tabExperienceProject ");
strSql.Append(" where id=SQL2012id");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
tabExperienceProjectModel model = new tabExperienceProjectModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ModelHandler <tabExperienceProjectModel> .FillModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabExperienceProjectModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabExperienceProjectModel model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabExperienceProjectModel model, List <string> ChangedFields)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tabExperienceProject set ");
strSql.Append(" OrgID = SQL2012OrgID , ");
strSql.Append(" ProjectName = SQL2012ProjectName , ");
strSql.Append(" ProjectBeginDate = SQL2012ProjectBeginDate , ");
strSql.Append(" ProjectEndDate = SQL2012ProjectEndDate , ");
strSql.Append(" ProjectDesc = SQL2012ProjectDesc , ");
strSql.Append(" ProjectPosition = SQL2012ProjectPosition , ");
strSql.Append(" ProjectPerformance = SQL2012ProjectPerformance , ");
strSql.Append(" AppID = SQL2012AppID , ");
strSql.Append(" Version = SQL2012Version , ");
strSql.Append(" RandomNo = SQL2012RandomNo , ");
strSql.Append(" ParentID = SQL2012ParentID , ");
strSql.Append(" Remark = SQL2012Remark , ");
strSql.Append(" LableText = SQL2012LableText , ");
strSql.Append(" ExJson = SQL2012ExJson , ");
strSql.Append(" Status = SQL2012Status , ");
strSql.Append(" OrderNo = SQL2012OrderNo , ");
strSql.Append(" CreateDate = SQL2012CreateDate , ");
strSql.Append(" ModifyDate = SQL2012ModifyDate , ");
strSql.Append(" CreateUser = SQL2012CreateUser , ");
strSql.Append(" ModifyUser = SQL2012ModifyUser ");
strSql.Append(" where id=SQL2012id ");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012OrgID", SqlDbType.Int, 4),
new SqlParameter("SQL2012ProjectName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectDesc", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012ProjectPosition", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectPerformance", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012id", SqlDbType.Int, 4),
new SqlParameter("SQL2012AppID", SqlDbType.NVarChar, 100),
new SqlParameter("SQL2012Version", SqlDbType.NVarChar, 100),
new SqlParameter("SQL2012RandomNo", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012ParentID", SqlDbType.Int, 4),
new SqlParameter("SQL2012Remark", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012LableText", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012ExJson", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012Status", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012OrderNo", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateDate", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012ModifyDate", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012CreateUser", SqlDbType.Int, 4),
new SqlParameter("SQL2012ModifyUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.OrgID;
parameters[1].Value = model.ProjectName;
parameters[2].Value = model.ProjectBeginDate;
parameters[3].Value = model.ProjectEndDate;
parameters[4].Value = model.ProjectDesc;
parameters[5].Value = model.ProjectPosition;
parameters[6].Value = model.ProjectPerformance;
parameters[7].Value = model.id;
parameters[8].Value = model.AppID;
parameters[9].Value = model.Version;
parameters[10].Value = model.RandomNo;
parameters[11].Value = model.ParentID;
parameters[12].Value = model.Remark;
parameters[13].Value = model.LableText;
parameters[14].Value = model.ExJson;
parameters[15].Value = model.Status;
parameters[16].Value = model.OrderNo;
parameters[17].Value = model.CreateDate;
parameters[18].Value = model.ModifyDate;
parameters[19].Value = model.CreateUser;
parameters[20].Value = model.ModifyUser;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabExperienceProjectModel model)
{
model.Version = model.Version.IsNotNullOrEmpty()? model.Version: "1";
model.RandomNo = model.RandomNo.IsNotNullOrEmpty()? model.RandomNo: Guid.NewGuid().ToString("N");
model.Status = model.Status.IsNotNullOrEmpty()? model.Status: "1";
model.OrderNo = model.OrderNo > 0? model.OrderNo: 1;
model.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.ModifyDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tabExperienceProject(");
strSql.Append("OrgID,ProjectName,ProjectBeginDate,ProjectEndDate,ProjectDesc,ProjectPosition,ProjectPerformance,AppID,Version,RandomNo,ParentID,Remark,LableText,ExJson,Status,OrderNo,CreateDate,ModifyDate,CreateUser,ModifyUser");
strSql.Append(") values (");
strSql.Append("SQL2012OrgID,SQL2012ProjectName,SQL2012ProjectBeginDate,SQL2012ProjectEndDate,SQL2012ProjectDesc,SQL2012ProjectPosition,SQL2012ProjectPerformance,SQL2012AppID,SQL2012Version,SQL2012RandomNo,SQL2012ParentID,SQL2012Remark,SQL2012LableText,SQL2012ExJson,SQL2012Status,SQL2012OrderNo,SQL2012CreateDate,SQL2012ModifyDate,SQL2012CreateUser,SQL2012ModifyUser");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012OrgID", SqlDbType.Int, 4),
new SqlParameter("SQL2012ProjectName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectDesc", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012ProjectPosition", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012ProjectPerformance", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012AppID", SqlDbType.NVarChar, 100),
new SqlParameter("SQL2012Version", SqlDbType.NVarChar, 100),
new SqlParameter("SQL2012RandomNo", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012ParentID", SqlDbType.Int, 4),
new SqlParameter("SQL2012Remark", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012LableText", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012ExJson", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012Status", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012OrderNo", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateDate", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012ModifyDate", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012CreateUser", SqlDbType.Int, 4),
new SqlParameter("SQL2012ModifyUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.OrgID;
parameters[1].Value = model.ProjectName;
parameters[2].Value = model.ProjectBeginDate;
parameters[3].Value = model.ProjectEndDate;
parameters[4].Value = model.ProjectDesc;
parameters[5].Value = model.ProjectPosition;
parameters[6].Value = model.ProjectPerformance;
parameters[7].Value = model.AppID;
parameters[8].Value = model.Version;
parameters[9].Value = model.RandomNo;
parameters[10].Value = model.ParentID;
parameters[11].Value = model.Remark;
parameters[12].Value = model.LableText;
parameters[13].Value = model.ExJson;
parameters[14].Value = model.Status;
parameters[15].Value = model.OrderNo;
parameters[16].Value = model.CreateDate;
parameters[17].Value = model.ModifyDate;
parameters[18].Value = model.CreateUser;
parameters[19].Value = model.ModifyUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
