public Model.tab_eticket geteticket(Model.tab_eticket eticket1)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from tab_eticket where ");
strsql.AppendFormat("id='{0}'", eticket1.id);
DataTable dt = sql.ExecuteDataSet(strsql.ToString()).Tables[0];
if (dt.Rows.Count < 1)
{
return(null);
}
Model.tab_eticket eticket = new Model.tab_eticket();
eticket.id = eticket1.id;
eticket.orderID = int.Parse(dt.Rows[0]["orderID"].ToString());
eticket.customerName = dt.Rows[0]["customerName"].ToString();
eticket.productName = dt.Rows[0]["productName"].ToString();
eticket.productID = int.Parse(dt.Rows[0]["productID"].ToString());
eticket.itemnum = dt.Rows[0]["itemnum"].ToString();
eticket.eticket = dt.Rows[0]["eticket"].ToString();
eticket.used = dt.Rows[0]["used"].ToString();
eticket.time = dt.Rows[0]["time"].ToString() == "" ? baddate : DateTime.Parse(dt.Rows[0]["time"].ToString());
eticket.note = dt.Rows[0]["note"].ToString();
return(eticket);
}
public int update(Model.tab_eticket eticket)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("update tab_eticket set ");
strsql.AppendFormat(" orderID ='{0}',", eticket.orderID);
strsql.AppendFormat(" customerName =N'{0}',", eticket.customerName);
strsql.AppendFormat(" productName =N'{0}',", eticket.productName);
strsql.AppendFormat(" productID ='{0}',", eticket.productID);
strsql.AppendFormat(" itemnum ='{0}',", eticket.itemnum);
strsql.AppendFormat(" eticket =N'{0}',", eticket.eticket);
strsql.AppendFormat(" used =N'{0}',", eticket.used);
strsql.AppendFormat(" time ={0},", eticket.time == baddate ? "null" : "'" + eticket.time.ToString() + "'");
strsql.AppendFormat(" note =N'{0}'", eticket.note);
strsql.AppendFormat(" where id={0}", eticket.id);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public int Add(Model.tab_eticket eticket)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into tab_eticket values (");
strsql.AppendFormat("{0},", eticket.orderID);
strsql.AppendFormat("N'{0}',", eticket.customerName);
strsql.AppendFormat("N'{0}',", eticket.productName);
strsql.AppendFormat("{0},", eticket.productID);
strsql.AppendFormat("'{0}',", eticket.itemnum);
strsql.AppendFormat("N'{0}',", eticket.eticket);
strsql.AppendFormat("N'{0}',", eticket.used);
strsql.AppendFormat("{0},", eticket.time == baddate ? "null" : "'" + eticket.time.ToString() + "'");
strsql.AppendFormat("N'{0}'", eticket.note);
strsql.Append(") select SCOPE_IDENTITY()");
return(Convert.ToInt32(sql.ExecuteSc(strsql.ToString())));
}
public int Add(Model.tab_eticket eticket)
{
return(itu.Add(eticket));
}
public int update(Model.tab_eticket eticket)
{
return(itu.update(eticket));
}
public Model.tab_eticket geteticket(Model.tab_eticket eticket1)
{
return(itu.geteticket(eticket1));
}
