62,017
社区成员
发帖
与我相关
我的任务
分享
[WebMethod]
public void MsgBackAddOrModi(int InputPersonID, string Isyscode, string CreatDate, string CusClass, string CusID, string Photo0, string Photo1, string Photo2, string Photo3)
{
string dbcon = ConfigurationManager.ConnectionStrings["AucmaZDCoon"].ToString();
SqlConnection conn = new SqlConnection(dbcon);
DataSet ds = null;
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sqlproc = "spMsgBackAddOrModi";
SqlCommand cmd = new SqlCommand(sqlproc, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PersonID", SqlDbType.Int, 4);
cmd.Parameters["@PersonID"].Direction = ParameterDirection.Input;
cmd.Parameters["@PersonID"].Value = InputPersonID;
……
//执行存储
SqlDataAdapter da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
int MsgBackID = Convert.ToInt32(ds.Tables[0].Rows[0][2].ToString());
byte[] arr = Convert.FromBase64String(photo0);
MemoryStream ms = new MemoryStream(arr);
Bitmap bmp = new Bitmap(ms);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + Guid.NewGuid().ToString().Substring(0, 5) + ".jpg";
bmp.Save("F:\\Pic\\" + filename, System.Drawing.Imaging.ImageFormat.Jpeg);
string url = "http://localhost/WebTest/pic/" + filename;
//执行保存图片路径跟主表ID的存储
Context.Response.Charset = "GB2312"; //设置字符集类型
Context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Context.Response.Write(“成功”);
}