/// <summary>
/// 得到一个对象实体
/// </summary>
public tabExperienceWorkModel GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from tabExperienceWork ");
strSql.Append(" where id=SQL2012id");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
tabExperienceWorkModel model = new tabExperienceWorkModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ModelHandler <tabExperienceWorkModel> .FillModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabExperienceWorkModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabExperienceWorkModel model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabExperienceWorkModel model, List <string> ChangedFields)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tabExperienceWork set ");
strSql.Append(" OrgID = SQL2012OrgID , ");
strSql.Append(" OrgBeginDate = SQL2012OrgBeginDate , ");
strSql.Append(" OrgEndDate = SQL2012OrgEndDate , ");
strSql.Append(" PositionName = SQL2012PositionName , ");
strSql.Append(" PositionAddress = SQL2012PositionAddress , ");
strSql.Append(" PositionBeginDate = SQL2012PositionBeginDate , ");
strSql.Append(" PositionEndDate = SQL2012PositionEndDate , ");
strSql.Append(" DeptNum = SQL2012DeptNum , ");
strSql.Append(" PositionDuties = SQL2012PositionDuties , ");
strSql.Append(" ReportObj = SQL2012ReportObj , ");
strSql.Append(" DeptName = SQL2012DeptName , ");
strSql.Append(" WorkPerformance = SQL2012WorkPerformance , ");
strSql.Append(" IsVal = SQL2012IsVal , ");
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("SQL2012OrgBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012OrgEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionAddress", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012PositionBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012DeptNum", SqlDbType.Int, 4),
new SqlParameter("SQL2012PositionDuties", SqlDbType.NVarChar, 1000),
new SqlParameter("SQL2012ReportObj", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012DeptName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012WorkPerformance", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012IsVal", SqlDbType.Bit, 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.OrgBeginDate;
parameters[2].Value = model.OrgEndDate;
parameters[3].Value = model.PositionName;
parameters[4].Value = model.PositionAddress;
parameters[5].Value = model.PositionBeginDate;
parameters[6].Value = model.PositionEndDate;
parameters[7].Value = model.DeptNum;
parameters[8].Value = model.PositionDuties;
parameters[9].Value = model.ReportObj;
parameters[10].Value = model.DeptName;
parameters[11].Value = model.WorkPerformance;
parameters[12].Value = model.IsVal;
parameters[13].Value = model.id;
parameters[14].Value = model.AppID;
parameters[15].Value = model.Version;
parameters[16].Value = model.RandomNo;
parameters[17].Value = model.ParentID;
parameters[18].Value = model.Remark;
parameters[19].Value = model.LableText;
parameters[20].Value = model.ExJson;
parameters[21].Value = model.Status;
parameters[22].Value = model.OrderNo;
parameters[23].Value = model.CreateDate;
parameters[24].Value = model.ModifyDate;
parameters[25].Value = model.CreateUser;
parameters[26].Value = model.ModifyUser;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabExperienceWorkModel 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 tabExperienceWork(");
strSql.Append("OrgID,OrgBeginDate,OrgEndDate,PositionName,PositionAddress,PositionBeginDate,PositionEndDate,DeptNum,PositionDuties,ReportObj,DeptName,WorkPerformance,IsVal,AppID,Version,RandomNo,ParentID,Remark,LableText,ExJson,Status,OrderNo,CreateDate,ModifyDate,CreateUser,ModifyUser");
strSql.Append(") values (");
strSql.Append("SQL2012OrgID,SQL2012OrgBeginDate,SQL2012OrgEndDate,SQL2012PositionName,SQL2012PositionAddress,SQL2012PositionBeginDate,SQL2012PositionEndDate,SQL2012DeptNum,SQL2012PositionDuties,SQL2012ReportObj,SQL2012DeptName,SQL2012WorkPerformance,SQL2012IsVal,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("SQL2012OrgBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012OrgEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionAddress", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012PositionBeginDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012PositionEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012DeptNum", SqlDbType.Int, 4),
new SqlParameter("SQL2012PositionDuties", SqlDbType.NVarChar, 1000),
new SqlParameter("SQL2012ReportObj", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012DeptName", SqlDbType.NVarChar, 50),
new SqlParameter("SQL2012WorkPerformance", SqlDbType.NVarChar, -1),
new SqlParameter("SQL2012IsVal", SqlDbType.Bit, 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.OrgBeginDate;
parameters[2].Value = model.OrgEndDate;
parameters[3].Value = model.PositionName;
parameters[4].Value = model.PositionAddress;
parameters[5].Value = model.PositionBeginDate;
parameters[6].Value = model.PositionEndDate;
parameters[7].Value = model.DeptNum;
parameters[8].Value = model.PositionDuties;
parameters[9].Value = model.ReportObj;
parameters[10].Value = model.DeptName;
parameters[11].Value = model.WorkPerformance;
parameters[12].Value = model.IsVal;
parameters[13].Value = model.AppID;
parameters[14].Value = model.Version;
parameters[15].Value = model.RandomNo;
parameters[16].Value = model.ParentID;
parameters[17].Value = model.Remark;
parameters[18].Value = model.LableText;
parameters[19].Value = model.ExJson;
parameters[20].Value = model.Status;
parameters[21].Value = model.OrderNo;
parameters[22].Value = model.CreateDate;
parameters[23].Value = model.ModifyDate;
parameters[24].Value = model.CreateUser;
parameters[25].Value = model.ModifyUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
