62,074
社区成员
发帖
与我相关
我的任务
分享
public static int MarkingByPricelistId(string pricelist_id)
{
int i = 0;
string sql = "update [pricelist] set del=1 where pricelist_id='" + pricelist_id + "'";
SqlConnection con = new SqlConnection(SqlHelper.ConnectionString);
con.Open();
SqlTransaction trans = con.BeginTransaction();
try
{
i = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, null);
trans.Commit();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(".................." + ex);
trans.Rollback();
}
finally
{
con.Close();
}
return i;
}
foreach (RepeaterItem ri in RepShowPriceLists.Items)
{
HyperLink HlkPricelistId = (HyperLink)ri.FindControl("HlkPriceListId");
int res = DAL.PricelistDAL.MarkingByPricelistId(HlkPricelistId.Text);
}