/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.LinkMans model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update LinkMans set ");
strSql.Append("CusID=@CusID,");
strSql.Append("LMName=@LMName,");
strSql.Append("LMSex=@LMSex,");
strSql.Append("LMDuty=@LMDuty,");
strSql.Append("LMMobileNo=@LMMobileNo,");
strSql.Append("LMOfficeNo=@LMOfficeNo,");
strSql.Append("LMMemo=@LMMemo");
strSql.Append(" where LMID=@LMID");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14),
new SqlParameter("@LMName", SqlDbType.NVarChar, 50),
new SqlParameter("@LMSex", SqlDbType.Char, 2),
new SqlParameter("@LMDuty", SqlDbType.NVarChar, 50),
new SqlParameter("@LMMobileNo", SqlDbType.VarChar, 50),
new SqlParameter("@LMOfficeNo", SqlDbType.VarChar, 50),
new SqlParameter("@LMMemo", SqlDbType.NVarChar, 500),
new SqlParameter("@LMID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CusID;
parameters[1].Value = model.LMName;
parameters[2].Value = model.LMSex;
parameters[3].Value = model.LMDuty;
parameters[4].Value = model.LMMobileNo;
parameters[5].Value = model.LMOfficeNo;
parameters[6].Value = model.LMMemo;
parameters[7].Value = model.LMID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.LinkMans DataRowToModel(DataRow row)
{
Maticsoft.Model.LinkMans model = new Maticsoft.Model.LinkMans();
if (row != null)
{
if (row["LMID"] != null && row["LMID"].ToString() != "")
{
model.LMID = int.Parse(row["LMID"].ToString());
}
if (row["CusID"] != null)
{
model.CusID = row["CusID"].ToString();
}
if (row["LMName"] != null)
{
model.LMName = row["LMName"].ToString();
}
if (row["LMSex"] != null)
{
model.LMSex = row["LMSex"].ToString();
}
if (row["LMDuty"] != null)
{
model.LMDuty = row["LMDuty"].ToString();
}
if (row["LMMobileNo"] != null)
{
model.LMMobileNo = row["LMMobileNo"].ToString();
}
if (row["LMOfficeNo"] != null)
{
model.LMOfficeNo = row["LMOfficeNo"].ToString();
}
if (row["LMMemo"] != null)
{
model.LMMemo = row["LMMemo"].ToString();
}
if (row["CusName"] != null)
{
model.CusName = row["CusName"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.LinkMans model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LinkMans(");
strSql.Append("CusID,LMName,LMSex,LMDuty,LMMobileNo,LMOfficeNo,LMMemo)");
strSql.Append(" values (");
strSql.Append("@CusID,@LMName,@LMSex,@LMDuty,@LMMobileNo,@LMOfficeNo,@LMMemo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14),
new SqlParameter("@LMName", SqlDbType.NVarChar, 50),
new SqlParameter("@LMSex", SqlDbType.Char, 2),
new SqlParameter("@LMDuty", SqlDbType.NVarChar, 50),
new SqlParameter("@LMMobileNo", SqlDbType.VarChar, 50),
new SqlParameter("@LMOfficeNo", SqlDbType.VarChar, 50),
new SqlParameter("@LMMemo", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.CusID;
parameters[1].Value = model.LMName;
parameters[2].Value = model.LMSex;
parameters[3].Value = model.LMDuty;
parameters[4].Value = model.LMMobileNo;
parameters[5].Value = model.LMOfficeNo;
parameters[6].Value = model.LMMemo;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.LinkMans GetModel(int LMID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 LMID,CusID,LMName,LMSex,LMDuty,LMMobileNo,LMOfficeNo,LMMemo from LinkMans ");
strSql.Append(" where LMID=@LMID");
SqlParameter[] parameters =
{
new SqlParameter("@LMID", SqlDbType.Int, 4)
};
parameters[0].Value = LMID;
Maticsoft.Model.LinkMans model = new Maticsoft.Model.LinkMans();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
