/// <summary>
/// 删除项目
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
public int DelteProject(string id, string userid)
{
string sql = "delete from Construction where ConstructionId=@id and SupportingId=@userid";
SqlParameter[] arr = new SqlParameter[] {
new SqlParameter("@id", id),
new SqlParameter("@userid", userid)
};
return(SqlHelperMeasure.ExecuteNonQuery(sql, arr));
}
/// <summary>
/// 保存项目
/// </summary>
/// <param name="CustomerName"></param>
/// <param name="phone"></param>
/// <param name="address"></param>
/// <param name="demanddesc"></param>
/// <param name="id"></param>
/// <returns></returns>
public string SaveItem(string CustomerName, string phone, string address, string demanddesc, string id)
{
#region MyRegion
string sql = "update Construction set ConstructionLxr=@CustomerName ,Phone=@phone,Start_qht=@address,Start=@demanddesc where ConstructionId=@id";
#endregion
SqlParameter[] arr = new SqlParameter[] {
new SqlParameter("@CustomerName", CustomerName),
new SqlParameter("@phone", phone),
new SqlParameter("@address", address),
new SqlParameter("@demanddesc", demanddesc),
new SqlParameter("@id", id)
};
return(SqlHelperMeasure.ExecuteNonQuery(sql, arr).ToSafeString());
}