//delete
public static int DeleteRecordByKey(string mID)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@mID", mID);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Module_DeleteRecordByKey", para));
}
//delete
public static int DeleteByKey(string userId)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@userid", userId);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Users_DeleteByKey", para));
}
//delete
public static int DeleteRecordByKey(string deptId)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@deptid", deptId);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "dept_DeleteByKey", para));
}
//delete record by key
public static int DeleteRecordByKey(string groupid)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@groupid", groupid);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Groups_DeleteRecordByKey", para));
}
//clearPwd
public static int ClearPassword(string userId, string password)
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@userid", userId);
para[1] = new SqlParameter("@password", password);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Users_ClearPwd", para));
}
//update Password
public static int UpdatePasswordByUserId(string userId, string oldPwd, string newPwd)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@userid", userId);
para[1] = new SqlParameter("@oldpassword", oldPwd);
para[2] = new SqlParameter("@newpassword", newPwd);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Users_UpdatePwdByUserId", para));
}
//update
public static int UpdateRecordByKey(string deptId, string newDeptName, string state)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@deptid", deptId);
para[1] = new SqlParameter("@newdeptname", newDeptName);
para[2] = new SqlParameter("@state", state);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "dept_UpdateByKey", para));
}
public static int bluebooth(string sn)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@sn", sn);
para[1] = new SqlParameter("@bluetooth_addr", SqlDbType.NVarChar, 50);
para[1].Direction = ParameterDirection.Output;
para[2] = new SqlParameter("@msg", SqlDbType.Int);
para[2].Direction = ParameterDirection.Output;
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "BLUETOOTH_ASSIGN", para));
}
//update record by key
public static int UpdateRecordByKey(string groupid, string groupname, string remark, string deptid, string creatGroup, string IsWeb)
{
SqlParameter[] para = new SqlParameter[6];
para[0] = new SqlParameter("@groupid", groupid);
para[1] = new SqlParameter("@groupname", groupname);
para[2] = new SqlParameter("@remark", remark);
para[3] = new SqlParameter("@deptid", deptid);
para[4] = new SqlParameter("@creatGroup", creatGroup);
para[5] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Groups_UpdateRecordByKey", para));
}
//update
public static int UpdateByKey(string userId, string userName, string groupId, string deptId, string tel, string deptid2, string groupBSid)
{
SqlParameter[] para = new SqlParameter[7];
para[0] = new SqlParameter("@userid", userId);
para[1] = new SqlParameter("@username", userName);
para[2] = new SqlParameter("@groupid", groupId);
para[3] = new SqlParameter("deptid", deptId);
para[4] = new SqlParameter("@tel", tel);
para[5] = new SqlParameter("@deptid2", deptid2);
para[6] = new SqlParameter("@groupBSid", groupBSid);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Users_UpdateByKey", para));
}
//delete record by groupID
public static bool DeleteRecordByGroupID(string groupID)
{
bool temp = false;
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@groupID", groupID);
if (DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "GroupPermission_DeleteRecordByGroupID", para) > 0)
{
temp = true;
}
return(temp);
}
//update
public static int UpdateRecordByKey(string mID, string mName, string mWindow, int mNo, string mParent, string mRule, string IsOper, string mDepts, string IsWeb)
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@mID", mID);
para[1] = new SqlParameter("@mName", mName);
para[2] = new SqlParameter("@mWindow", mWindow);
para[3] = new SqlParameter("@mNo", mNo);
para[4] = new SqlParameter("@mParent", mParent);
para[5] = new SqlParameter("@mRule", mRule);
para[6] = new SqlParameter("@IsOper", IsOper);
para[7] = new SqlParameter("@mDepts", mDepts);
para[8] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Module_UpdateRecordByKey", para));
}
public static string MailOperate(string action, string dept, string username, string userid, string type, string loginuser, string id, string mailType)
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@operType", action);
para[1] = new SqlParameter("@deptid", dept);
para[2] = new SqlParameter("@username", username);
para[3] = new SqlParameter("@usermail", userid);
para[4] = new SqlParameter("@sendtype", type);
para[5] = new SqlParameter("@loginuser", loginuser);
para[6] = new SqlParameter("@id", id);
para[7] = new SqlParameter("@mailType", mailType);
para[8] = new SqlParameter("@resultMsg", SqlDbType.VarChar, 200);
para[8].Direction = ParameterDirection.Output;
DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "SYS_ProdRepair_Mail", para);
return(para[8].Value.ToString());
}
public static int AddTTSSet(string opertype, string ttype, string tdate, string time1, string time2, string tcontent, string maleorfemale, string forqty, string email, string userid)
{
SqlParameter[] para = new SqlParameter[10];
para[0] = new SqlParameter("@opertype", opertype);
para[1] = new SqlParameter("@ttype", ttype);
para[2] = new SqlParameter("@tdate", tdate);
para[3] = new SqlParameter("@time1", time1);
para[4] = new SqlParameter("@time2", time2);
para[5] = new SqlParameter("@tcontent", tcontent);
para[6] = new SqlParameter("@maleorfemale", maleorfemale);
para[7] = new SqlParameter("@forqty", forqty);
para[8] = new SqlParameter("@email", email);
para[9] = new SqlParameter("@userid", userid);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "SMT_TTSSetAdd", para));
}
public static string UpdateProdTest(string sn, string wo, string mo, string model, string shipaddress, string checkuser, string checkdate, string checkresult, string remark, string loginuser)
{
SqlParameter[] para = new SqlParameter[11];
para[0] = new SqlParameter("@sn", sn);
para[1] = new SqlParameter("@wo", wo);
para[2] = new SqlParameter("@mo", mo);
para[3] = new SqlParameter("@model", model);
para[4] = new SqlParameter("@shipaddress", shipaddress);
para[5] = new SqlParameter("@checkuser", checkuser);
para[6] = new SqlParameter("@checkdate", checkdate);
para[7] = new SqlParameter("@checkresult", checkresult);
para[8] = new SqlParameter("@remarks", remark);
para[9] = new SqlParameter("@operUser", loginuser);
para[10] = new SqlParameter("@errormsg", SqlDbType.VarChar, 200);
para[10].Direction = ParameterDirection.Output;
DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "SYS_ProdTest_Update", para);
return(para[10].Value.ToString());
}
public static int DeleteProdTest(string sn)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@sn", sn);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "SYS_ProdTest_Delete", para));
}
