/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.KCInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from KCInfo ");
strSql.Append(" where GoodsID=@GoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.GoodsID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.KCInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KCInfo set ");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("DepotName=@DepotName,");
strSql.Append("GoodsNum=@GoodsNum,");
strSql.Append("AlarmNum=@AlarmNum");
strSql.Append(" where GoodsID=@GoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@DepotName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsNum", SqlDbType.Int),
new SqlParameter("@AlarmNum", SqlDbType.Int)
};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.GoodsName;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.DepotName;
parameters[4].Value = model.GoodsNum;
parameters[5].Value = model.AlarmNum;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.CompanyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CompanyInfo(");
strSql.Append("CompanyID,CompanyName,CompanyDirector,CompanyPhone,CompanyAddress,CompanyRemarks,ReDateTime,Flag)");
strSql.Append(" values (");
strSql.Append("@CompanyID,@CompanyName,@CompanyDirector,@CompanyPhone,@CompanyAddress,@CompanyRemarks,@ReDateTime,@Flag)");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyDirector", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyRemarks", SqlDbType.NVarChar, 200),
new SqlParameter("@ReDateTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.CompanyID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CompanyDirector;
parameters[3].Value = model.CompanyPhone;
parameters[4].Value = model.CompanyAddress;
parameters[5].Value = model.CompanyRemarks;
parameters[6].Value = model.ReDateTime;
parameters[7].Value = model.Flag;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static void UpdateVid(MyFileInfo fi)
{
string sql = "update files set vid='" + fi.Vid + "' where fileId=" + fi.FileId;
DBHelper.ExecuteSql(sql);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.JHGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JHGoodsInfo set ");
strSql.Append("EmployeeID=@EmployeeID,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("DepotName=@DepotName,");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("GoodsNum=@GoodsNum,");
strSql.Append("GoodsUnit=@GoodsUnit,");
strSql.Append("GoodsJHPrice=@GoodsJHPrice,");
strSql.Append("GoodsSellPrice=@GoodsSellPrice,");
strSql.Append("GoodsNeedPay=@GoodsNeedPay,");
strSql.Append("GoodsHasPay=@GoodsHasPay,");
strSql.Append("GoodsRemark=@GoodsRemark,");
strSql.Append("GoodsTime=@GoodsTime ");
strSql.Append(" where GoodsID=@GoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@DepotName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsNum", SqlDbType.Int),
new SqlParameter("@GoodsUnit", SqlDbType.NVarChar, 20),
new SqlParameter("@GoodsJHPrice", SqlDbType.Float),
new SqlParameter("@GoodsSellPrice", SqlDbType.Float),
new SqlParameter("@GoodsNeedPay", SqlDbType.Float),
new SqlParameter("@GoodsHasPay", SqlDbType.Float),
new SqlParameter("@GoodsRemark", SqlDbType.NVarChar, 200),
new SqlParameter("@GoodsTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.EmployeeID;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.DepotName;
parameters[4].Value = model.GoodsName;
parameters[5].Value = model.GoodsNum;
parameters[6].Value = model.GoodsUnit;
parameters[7].Value = model.GoodsJHPrice;
parameters[8].Value = model.GoodsSellPrice;
parameters[9].Value = model.GoodsNeedPay;
parameters[10].Value = model.GoodsHasPay;
parameters[11].Value = model.GoodsRemark;
parameters[12].Value = model.GoodsTime;
parameters[13].Value = model.Flag;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static int Update(UserState us)
{
string sql = "update userstate_tab set name='" + us.Name + "' where id=" + us.Id;
return(DBHelper.ExecuteSql(sql));
}
public static int Delete(UserState us)
{
string sql = "delete userstate_tab where id=" + us.Id;
return(DBHelper.ExecuteSql(sql));
}
public static int Insert(UserState us)
{
string sql = "insert into userstate_tab values('" + us.Name + "')";
return(DBHelper.ExecuteSql(sql));
}
public bool UpdateOneTime(int num, string upDate)
{
string sql = String.Format(@"Update DeadLine set DateItem='{0}' where ID={1}", upDate, num);
DBHelper dbh = new DBHelper();
return dbh.ExecuteSql(sql);
}
public bool UpdateOneItem(int num,string upDate,string upCon)
{
string sql = String.Format(@"Update DeadLine set DateItem='{0}',ContentItem='{1}' where ID={2}", upDate, upCon, num);
DBHelper dbh = new DBHelper();
return dbh.ExecuteSql(sql);
}
public bool DeleteOneItem(string tab,int userID)
{
string sql = string.Format(@"delete from {0} where ID={1}", tab,userID);
DBHelper dbh = new DBHelper();
return dbh.ExecuteSql(sql);
}
public bool AddOneItem(string remindDate, string remindCon)
{
string sql = String.Format(@"insert into DeadLine(DateItem,ContentItem) values('{0}','{1}')", remindDate, remindCon);
DBHelper dbh = new DBHelper();
return dbh.ExecuteSql(sql);
}
public static int Update(User u)
{
string sql = "update user_tab set name='" + u.Name + "',address='" + u.Address + "',tel='" + u.Tel + "',email='" + u.Email + "',state=" + u.User_state.Id + " where id=" + u.Id;
return(DBHelper.ExecuteSql(sql));
}
public static int Insert(User u)
{
string sql = "insert into user_tab values('" + u.Name + "','" + u.Address + "','" + u.Tel + "','" + u.Email + "'," + u.User_state.Id + ")";
return(DBHelper.ExecuteSql(sql));
}
