public void p_bed_update(int i, int j)
{
SqlParameter Idsickroom = new SqlParameter("@Idsickroom", SqlDbType.Int);
SqlParameter Idbed = new SqlParameter("@Idbed", SqlDbType.Int);
Idsickroom.Value = i;
Idbed.Value = j;
SqlParameter[] sp = { Idsickroom, Idbed };
DBHelper.ExecuteNonQueryProc("p_bed_update", sp);
}
public void SectionRoomUpdate(SectionRoom s)
{
SqlParameter Sname = new SqlParameter("@Sname", SqlDbType.VarChar);
SqlParameter Saddr = new SqlParameter("@Saddr", SqlDbType.VarChar);
SqlParameter Sprice = new SqlParameter("@Sprice", SqlDbType.Int);
Sname.Value = s.Sname;
Saddr.Value = s.Saddr;
Sprice.Value = s.Sprice;
SqlParameter[] ps = { Sname, Saddr, Sprice };
DBHelper.ExecuteNonQueryProc("p_SectionRoom_Update", ps);
}
public string p_usersType_insert(string name, string str)
{
SqlParameter Type = new SqlParameter("@Type", SqlDbType.Char);
SqlParameter peodom = new SqlParameter("@peodom", SqlDbType.Char);
SqlParameter mess = new SqlParameter("@mess", SqlDbType.VarChar, 20);
mess.Direction = ParameterDirection.Output;
Type.Value = name;
peodom.Value = str;
SqlParameter[] sp = { Type, peodom, mess };
DBHelper.ExecuteNonQueryProc("p_usersType_insert", sp);
return(mess.Value + "");
}
/// <summary>
/// 添加住院费用
/// </summary>
/// <param name="xfs"></param>
public void p_zhuyuanxiaofei_insert(List <zhuyuanxiaofei> xfs)
{
foreach (zhuyuanxiaofei item in xfs)
{
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
SqlParameter yaoName = new SqlParameter("@yaoName", SqlDbType.Char);
SqlParameter yaonum = new SqlParameter("@yaonum", SqlDbType.Int);
kId.Value = item.kId;
yaoName.Value = item.yaoName;
yaonum.Value = item.yaonum;
SqlParameter[] sp = { kId, yaoName, yaonum };
bool f = DBHelper.ExecuteNonQueryProc("p_zhuyuanxiaofei_insert", sp);
}
}
public void p_zhuayuantongji_select(zhuayuantongji zhu)
{
SqlParameter Kid = new SqlParameter("@Kid", SqlDbType.Int);
SqlParameter Sname = new SqlParameter("@Sname", SqlDbType.Char);
SqlParameter zmoney = new SqlParameter("@zmoney", SqlDbType.Int);
SqlParameter ymoney = new SqlParameter("@ymoney", SqlDbType.Int);
SqlParameter time = new SqlParameter("@time", SqlDbType.Char);
Kid.Value = zhu.Kid;
Sname.Value = zhu.Sname;
zmoney.Value = zhu.zmoney;
ymoney.Value = zhu.ymoney;
time.Value = zhu.time;
SqlParameter[] sp = { Kid, Sname, zmoney, ymoney, time };
DBHelper.ExecuteNonQueryProc("p_zhuayuantongji_select", sp);
}
public int Delete(Drug_insert di)
{
SqlParameter Dname = new SqlParameter("@DName", SqlDbType.VarChar);
Dname.Value = di.Dname;
SqlParameter[] sp = { Dname };
bool f = DBHelper.ExecuteNonQueryProc("Drug_Delete_p", sp);
if (f)
{
return(0); //(int)result.Value;
}
else
{
return(-1);
}
}
/// <summary>
/// 病房添加
/// </summary>
/// <param name="sics"></param>
/// <param name="num"></param>
/// <returns></returns>
public string sickroom(List <Sickroom> sics, int num)
{
foreach (Sickroom item in sics)
{
SqlParameter Idsickroom = new SqlParameter("@Idsickroom", SqlDbType.Int);
SqlParameter Tyep = new SqlParameter("@Type", SqlDbType.Char);
SqlParameter Sid = new SqlParameter("@Sid", SqlDbType.Int);
SqlParameter Price = new SqlParameter("@Price", SqlDbType.Int);
SqlParameter result = new SqlParameter("@result", SqlDbType.Char, 30);
result.Direction = ParameterDirection.Output;
Idsickroom.Value = item.Idsickroom;
Tyep.Value = item.Tyep;
Sid.Value = item.Sid;
Price.Value = item.Price;
SqlParameter[] sp = { Idsickroom, Tyep, Sid, Price, result };
bool f = DBHelper.ExecuteNonQueryProc("p_sickroom_insert", sp);
if (!f)
{
return("系统出错");
}
string str = result.Value + "";
if ((result.Value + "").Substring(0, 2) != "OK")
{
return("出现相同的房号!");
}
}
foreach (Sickroom item in sics)
{
for (int i = 0; i < num; i++)
{
SqlParameter Idsickroom = new SqlParameter("@Idsickroom", SqlDbType.Int);
SqlParameter Idbed = new SqlParameter("@Idbed", SqlDbType.Int);
SqlParameter KId = new SqlParameter("@KId", SqlDbType.Int);
SqlParameter State = new SqlParameter("@State", SqlDbType.Char);
Idsickroom.Value = item.Idsickroom;
Idbed.Value = i + 1;
KId.Value = 0;
State.Value = "空";
SqlParameter[] sp = { Idsickroom, Idbed, KId, State };
bool f = DBHelper.ExecuteNonQueryProc("p_bed_insert", sp);
}
}
return("添加成功");
}
public int Insert(Drug_insert di)
{
SqlParameter Dname = new SqlParameter("@DName", SqlDbType.VarChar);
SqlParameter Dtype = new SqlParameter("@Dtype", SqlDbType.VarChar);
SqlParameter DcostName = new SqlParameter("@DcostName", SqlDbType.VarChar);
SqlParameter Dspec = new SqlParameter("@Dspec", SqlDbType.VarChar);
SqlParameter DjiXing = new SqlParameter("@DjiXing", SqlDbType.VarChar);
SqlParameter DinsertPrice = new SqlParameter("@DinsertPrice", SqlDbType.Int);
SqlParameter DsellPrice = new SqlParameter("@DsellPrice", SqlDbType.Int);
SqlParameter Dstock = new SqlParameter("@Dstock", SqlDbType.Int);
SqlParameter DstockMax = new SqlParameter("@DstockMax", SqlDbType.Int);
SqlParameter DstockMin = new SqlParameter("@DstockMin", SqlDbType.Int);
SqlParameter DeffectTime = new SqlParameter("@DeffectTime", SqlDbType.SmallDateTime);
SqlParameter DproductTime = new SqlParameter("@DproductTime", SqlDbType.SmallDateTime);
SqlParameter Efficay = new SqlParameter("@Efficay", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
Dname.Value = di.Dname;
Dtype.Value = di.Dtype;
DcostName.Value = di.DcostName;
Dspec.Value = di.Dspec;
DjiXing.Value = di.DjiXing;
DinsertPrice.Value = di.DinsertPrice;
DsellPrice.Value = di.DsellPrice;
Dstock.Value = di.Dstock;
DstockMax.Value = di.DstockMax;
DstockMin.Value = di.DstockMin;
DeffectTime.Value = di.DeffectTime;
DproductTime.Value = di.DproductTime;
Efficay.Value = di.Efficay;
SqlParameter[] sp = { Dname, Dtype, DcostName, Dspec, DjiXing, DinsertPrice, DsellPrice, Dstock, DstockMax, DstockMin, DeffectTime, DproductTime, Efficay, result };
bool f = DBHelper.ExecuteNonQueryProc("Drug_insert_p", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
public string SonDelteDal(SectionRoomSo s)
{
SqlParameter SonName = new SqlParameter("@SonName", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.VarChar, 20);
result.Direction = ParameterDirection.Output;
SonName.Value = s.SonSname;
SqlParameter[] ps = { SonName, result };
bool f = DBHelper.ExecuteNonQueryProc("p_SectionRooomSonDelete", ps);
if (f)
{
return(result.Value + "");
}
else
{
return("出现异常");
}
}
public int Bingli_Insert(Bingli bl)
{
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
SqlParameter Rid = new SqlParameter("@Rid", SqlDbType.VarChar);
SqlParameter bing = new SqlParameter("@bing", SqlDbType.VarChar);
SqlParameter zhusu = new SqlParameter("@zhusu", SqlDbType.VarChar);
SqlParameter xianbingshi = new SqlParameter("@xianbingshi", SqlDbType.VarChar);
SqlParameter jiwangbingshi = new SqlParameter("@jiwangbingshi", SqlDbType.VarChar);
SqlParameter guominshi = new SqlParameter("@guominshi", SqlDbType.VarChar);
SqlParameter geirenshi = new SqlParameter("@geirenshi", SqlDbType.VarChar);
SqlParameter jiatingshi = new SqlParameter("@jiatingshi", SqlDbType.VarChar);
SqlParameter tijian = new SqlParameter("@tijian", SqlDbType.VarChar);
SqlParameter fuzhu = new SqlParameter("@fuzhu", SqlDbType.VarChar);
SqlParameter zhiliaojianyi = new SqlParameter("@zhiliaojianyi", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
kId.Value = bl.kId;
Rid.Value = bl.Rid;
bing.Value = bl.bing;
zhusu.Value = bl.zhusu;
xianbingshi.Value = bl.xianbingshi;
jiwangbingshi.Value = bl.jiwangbingshi;
guominshi.Value = bl.guominshi;
geirenshi.Value = bl.geirenshi;
jiatingshi.Value = bl.jiatingshi;
tijian.Value = bl.tijian;
fuzhu.Value = bl.fuzhu;
zhiliaojianyi.Value = bl.zhiliaojianyi;
SqlParameter[] sp = { kId, Rid, bing, zhusu, xianbingshi, jiwangbingshi, guominshi, geirenshi, jiatingshi, tijian, fuzhu, zhiliaojianyi, result };
bool f = DBHelper.ExecuteNonQueryProc("Bingli_insert", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
/// <summary>
/// 住院病人信息添加
/// </summary>
/// <param name="zhu"></param>
/// <returns></returns>
public string p_zhuyuan_insert(zhuyuan zhu)
{
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
SqlParameter Sid = new SqlParameter("@Sid", SqlDbType.Int);
SqlParameter Idsickroom = new SqlParameter("@Idsickroom", SqlDbType.Int);
SqlParameter BedNo = new SqlParameter("@BedNo", SqlDbType.Char);
SqlParameter Imprest = new SqlParameter("@Imprest", SqlDbType.Int);
SqlParameter Bewrite = new SqlParameter("@Bewrite", SqlDbType.Char);
SqlParameter Tabu = new SqlParameter("@Tabu", SqlDbType.Char);
SqlParameter Ztime = new SqlParameter("@Ztime", SqlDbType.Char);
SqlParameter result = new SqlParameter("@result", SqlDbType.Char, 2);
result.Direction = ParameterDirection.Output;
kId.Value = zhu.kId;
Sid.Value = zhu.Sid;
Idsickroom.Value = zhu.Idsickroom;
BedNo.Value = zhu.BedNo;
Imprest.Value = zhu.Imprest;
Bewrite.Value = zhu.Bewrite;
Tabu.Value = zhu.Tabu;
Ztime.Value = zhu.Ztime;
SqlParameter[] sp = { kId, Sid, Idsickroom, BedNo, Imprest, Bewrite, Tabu, Ztime, result };
bool f = DBHelper.ExecuteNonQueryProc("p_zhuyuan_insert", sp);
if (result.Value + "" == "KO")
{
return("此卡已申请过!");
}
if (result.Value + "" == "NO")
{
return("此卡不存在，请确认输入正确!");
}
else if (f)
{
return("提交成功,需预交费" + Imprest.Value + "元!");
}
else
{
return("系统出错");
}
}
/// <summary>
/// 卡号添加
/// </summary>
/// <param name="ic"></param>
/// <returns></returns>
public int Reg(IdCard ic)
{
SqlParameter name = new SqlParameter("@name", SqlDbType.VarChar);
SqlParameter sex = new SqlParameter("@sex", SqlDbType.Char);
SqlParameter age = new SqlParameter("@age", SqlDbType.Int);
SqlParameter Birthday = new SqlParameter("@Birthday", SqlDbType.SmallDateTime);
SqlParameter address = new SqlParameter("@address", SqlDbType.VarChar);
SqlParameter phone = new SqlParameter("@phone", SqlDbType.Char);
SqlParameter nation = new SqlParameter("@nation", SqlDbType.VarChar);
SqlParameter Cultrue = new SqlParameter("@Cultrue", SqlDbType.VarChar);
SqlParameter Marriage = new SqlParameter("@Marriage", SqlDbType.Char);
SqlParameter Work = new SqlParameter("@Work", SqlDbType.VarChar);
SqlParameter Postcode = new SqlParameter("@Postcode", SqlDbType.Int);
SqlParameter IdcardNo = new SqlParameter("@IdcardNo", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
name.Value = ic.Name;
sex.Value = ic.Sex;
age.Value = ic.Age;
Birthday.Value = ic.Birthday;
address.Value = ic.Address;
phone.Value = ic.Phone;
nation.Value = ic.Nation;
Cultrue.Value = ic.Cultrue;
Marriage.Value = ic.Marriage;
Work.Value = ic.Work;
Postcode.Value = ic.Postcode;
IdcardNo.Value = ic.IdcardNo;
SqlParameter[] sp = { name, sex, age, Birthday, address, phone, nation, Cultrue, Marriage, Work, Postcode, IdcardNo, result };
bool f = DBHelper.ExecuteNonQueryProc("Reg_IdCard", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
public string p_users_insert(Users u)
{
SqlParameter Uname = new SqlParameter("@Uname", SqlDbType.Char);
SqlParameter Pwd = new SqlParameter("@Pwd", SqlDbType.Char);
SqlParameter Sex = new SqlParameter("@Sex", SqlDbType.Char);
SqlParameter Address = new SqlParameter("@Address", SqlDbType.Char);
SqlParameter Phone = new SqlParameter("@Phone", SqlDbType.Char);
SqlParameter Spell = new SqlParameter("@Spell", SqlDbType.Char);
SqlParameter Type = new SqlParameter("@Type", SqlDbType.Char);
SqlParameter money = new SqlParameter("@money", SqlDbType.Int);
SqlParameter Peodom = new SqlParameter("@Peodom", SqlDbType.Char);
SqlParameter Section = new SqlParameter("@SectionRoom", SqlDbType.Char);
SqlParameter name = new SqlParameter("@name", SqlDbType.Char);
SqlParameter result = new SqlParameter("@result", SqlDbType.Char, 30);
result.Direction = ParameterDirection.Output;
Uname.Value = u.Uname;
Pwd.Value = u.Pwd;
Sex.Value = u.Sex;
Address.Value = u.Address;
Phone.Value = u.Phone;
Spell.Value = u.Spell;
Type.Value = u.Type;
money.Value = u.money;
Section.Value = u.SectionRoom;
Peodom.Value = u.Peodom;
name.Value = u.name;
SqlParameter[] sp = { Uname, name, Pwd, Sex, Address, Phone, Spell, Type, Section, money, Peodom, result };
bool f = DBHelper.ExecuteNonQueryProc("p_users_insert", sp);
if (!f)
{
return("系统出错");
}
string str = result.Value + "";
return(str);
}
public string SectionRoomChuan(SectionRoom s)
{
SqlParameter Sname = new SqlParameter("@Sname", SqlDbType.VarChar);
SqlParameter Saddr = new SqlParameter("@Saddr", SqlDbType.VarChar);
SqlParameter Sprice = new SqlParameter("@Sprice", SqlDbType.Int);
SqlParameter result = new SqlParameter("@result", SqlDbType.VarChar, 10);
result.Direction = ParameterDirection.Output;
Sname.Value = s.Sname;
Saddr.Value = s.Saddr;
Sprice.Value = s.Sprice;
SqlParameter[] ps = { Sname, Saddr, Sprice, result };
bool f = DBHelper.ExecuteNonQueryProc("p_SectionRoom", ps);
if (f)
{
return(1 + "");
}
else
{
return(result + "");
}
}
