/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Activitys model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Activitys set ");
strSql.Append("CusID=@CusID,");
strSql.Append("ActDate=@ActDate,");
strSql.Append("ActAdd=@ActAdd,");
strSql.Append("ActTitle=@ActTitle,");
strSql.Append("ActMemo=@ActMemo,");
strSql.Append("ActDesc=@ActDesc");
strSql.Append(" where ActID=@ActID");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14),
new SqlParameter("@ActDate", SqlDbType.DateTime),
new SqlParameter("@ActAdd", SqlDbType.NVarChar, 100),
new SqlParameter("@ActTitle", SqlDbType.NVarChar, 100),
new SqlParameter("@ActMemo", SqlDbType.NVarChar, 100),
new SqlParameter("@ActDesc", SqlDbType.NVarChar, -1),
new SqlParameter("@ActID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CusID;
parameters[1].Value = model.ActDate;
parameters[2].Value = model.ActAdd;
parameters[3].Value = model.ActTitle;
parameters[4].Value = model.ActMemo;
parameters[5].Value = model.ActDesc;
parameters[6].Value = model.ActID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Activitys model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Activitys(");
strSql.Append("CusID,ActDate,ActAdd,ActTitle,ActMemo,ActDesc)");
strSql.Append(" values (");
strSql.Append("@CusID,@ActDate,@ActAdd,@ActTitle,@ActMemo,@ActDesc)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14),
new SqlParameter("@ActDate", SqlDbType.DateTime),
new SqlParameter("@ActAdd", SqlDbType.NVarChar, 100),
new SqlParameter("@ActTitle", SqlDbType.NVarChar, 100),
new SqlParameter("@ActMemo", SqlDbType.NVarChar, 100),
new SqlParameter("@ActDesc", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.CusID;
parameters[1].Value = model.ActDate;
parameters[2].Value = model.ActAdd;
parameters[3].Value = model.ActTitle;
parameters[4].Value = model.ActMemo;
parameters[5].Value = model.ActDesc;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Activitys GetModel(int ActID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ActID,CusID,ActDate,ActAdd,ActTitle,ActMemo,ActDesc from Activitys ");
strSql.Append(" where ActID=@ActID");
SqlParameter[] parameters =
{
new SqlParameter("@ActID", SqlDbType.Int, 4)
};
parameters[0].Value = ActID;
Maticsoft.Model.Activitys model = new Maticsoft.Model.Activitys();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Activitys DataRowToModel(DataRow row)
{
Maticsoft.Model.Activitys model = new Maticsoft.Model.Activitys();
if (row != null)
{
if (row["ActID"] != null && row["ActID"].ToString() != "")
{
model.ActID = int.Parse(row["ActID"].ToString());
}
if (row["CusID"] != null)
{
model.CusID = row["CusID"].ToString();
}
if (row["ActDate"] != null && row["ActDate"].ToString() != "")
{
model.ActDate = DateTime.Parse(row["ActDate"].ToString());
}
if (row["ActAdd"] != null)
{
model.ActAdd = row["ActAdd"].ToString();
}
if (row["ActTitle"] != null)
{
model.ActTitle = row["ActTitle"].ToString();
}
if (row["ActMemo"] != null)
{
model.ActMemo = row["ActMemo"].ToString();
}
if (row["ActDesc"] != null)
{
model.ActDesc = row["ActDesc"].ToString();
}
}
return(model);
}
//添加
public int Add(Maticsoft.Model.Activitys ActAdd)
{
BLL.Activitys actBLL = new BLL.Activitys();
return(actBLL.Add(ActAdd));
}
